[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:1.9.2.20) 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!
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