|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?
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 -l2.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 Sihaphommail. address@hiddenOn 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!
|[Prev in Thread]||Current Thread||[Next in Thread]|