[Top][All Lists]

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

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

From: Maria Cecilia Santos Popper
Subject: Re: [Health-dev] Fwd: GNU Health DB Restore error
Date: Tue, 30 Sep 2014 08:24:59 -0300

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

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.


> Thanks very much for your help!
> Jakob

reply via email to

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