Re: [Health-dev] Fwd: GNU Health DB Restore error

[Maria Cecilia Santos Popper]

Cool!
I think this a keeper for the new documentation project!
Anyone else that would like to share their way of restoring a bd?

El 27/09/2014 19:29, "Bounmy Sihaphom" <address@hidden> escribió:

Hi all!

Just want to share and add to Luis steps, how I am doing db restore, I am not sure if it is a good or bad but it works great.My situation here is ( Ubuntu 14.04):

To restore (Manually) from pg_dump file:

1.Check now many database running on your system by typing: psql -l

2.createdb -T template0 mydbName  , you should see mydbName listing by typing above command.

2. psql mydbName > bakupFrompg_dumpFile  

(backupFrompg_dumpFile is the name of the backup file using manually pg_dump command) 

Hope it will helps.

Best Regards;

Bounmy Sihaphom

mail. address@hidden

On Sat, Sep 27, 2014 at 9:51 PM, Luis Falcon <address@hidden> wrote:

Hi Jakob
On Thu, 25 Sep 2014 07:51:36 +0200
Jakob Lang <address@hidden> wrote:

> Hi everyone,
>
> I just found a strange looking error when trying to save & restore a
> GNU health database.
> The save works fine but when doing the restore I get an error but the
> database seems to be restored fine anyway (I did not find any missing
> data yet).
> Is this a known problem? Anything I am doing wrong?
>
> Here is the error I get:
>
> In the Tryton client:
>
>
> On the Tryton server:
>
>
> The installation I have is the latest version of GNU health installed
> as described in the Wiki running on Ubuntu 12_4 and it also happens
> if I have the server running on Arch-Linux.

I always use pg_dump to do the backup, within a script to do unattended
backups in a cron job. For the restore, just psql . They work great and
I haven't have any issue with this procedure in all these years.

That said, the interactive backup from the client should work,
although I don't use it. Let's check with the Tryton community if they
have faced this problem.

Best,

>
> Thanks very much for your help!
> Jakob