[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Health] GNU Health Database Copying

From: Christoph H. Larsen
Subject: Re: [Health] GNU Health Database Copying
Date: Mon, 20 Feb 2012 21:23:23 +0430
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv: Gecko/20110820 Iceowl/1.0b2 Icedove/3.1.12

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

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

reply via email to

[Prev in Thread] Current Thread [Next in Thread]