Re: [Health] GNU Health Database Copying

[Christoph H. Larsen]

Thanks Luis,

On 20/02/12 23:03, Luis Falcon wrote:
> Hey Chris
> 
> On Mon, Feb 20, 2012 at 1:33 PM, Christoph H. Larsen
> <address@hidden> 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
>>
> 
> I do it this way. It works just fine
> 
> Backup :
> $ pg_dump gnuhealthdb > health_dump.sql
> 
> DB Creation and restore to a new db name
> 
> $createdb newdb
> $psql newdb < health_dump.sql
Yes, and - and here I got stuck, stupid me - DO restart your trytond
server!!! Also, DO rename your data hash directory in the tryton home
directory in order to capture any files you might have attached to any
record!
Thanks!
> 
> Best
> 

-- 
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