Re: [Health] GNU Health Database Copying

[Christoph H. Larsen]

"The best questions are those you can answer yourself..."
Long day. When making ANY changes to the database at the database level,
restart the PostgreSQL (not always required, actually), but DO restart
trytond :-).
Did I say: Long day?
Just in case somebody else falls into this silly trap!
Chris

On 20/02/12 21:03, Christoph H. Larsen wrote:
> Dear All,
> 
> I have some weird problems when trying to copy the data from my existing
> pilot_database to the production_database. Hey, copying a database is
> not magic, just a matter of:
> dump the pilot_database,
> createdb -O tryton -E utf8 production_database,
> psql production_database < ./pilot_database_dump
> 
> But no! All I get out of this is the bare-bone Administration menu
> entry. Restoring the pilot_database to itself works, though.
> 
> So, I thought, let's do:
> 
> dump the pilot_database,
> createdb -O tryton -E utf8 -T pilot_database production_database,
> psql production_database < ./pilot_database_dump
> 
> No fun, either. This is weird. Any ideas?
> 
> Thanks a lot!
> 
> Chris

-- 
Dr. Christoph H. Larsen
synaLinQ (Vietnam)                      synaLinQ (Kenya)
P.O. Box 55, Bưu điện NT, 01 Pasteur    P.O. Box 1607, Village Market
Nha Trang, Khánh Hòa                    Nairobi 00621
Vietnam                                 Kenya
Mobile: +84-98-9607357                  Mobile: +254-753-632481
        +49-176-96456254 (Germany)
Fax:    +49-231-292734790
Email:  address@hidden