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

[Luis Falcon]

Thanks a lot, Bounmy for your very helpful info !

Just a couple of comments
On Sun, 28 Sep 2014 05:29:27 +0700
Bounmy Sihaphom <address@hidden> wrote:

> 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.
I like to add the encoding ( --encoding=unicode ), so something like
$ createdb mydbName --encoding=unicode

You can double check the encoding of your existing DBs with the
same command you have mentioned "psql -l"

> 2. psql mydbName > bakupFrompg_dumpFile
> (backupFrompg_dumpFile is the name of the backup file using manually
> pg_dump command)
There is a typo in your command. Instead of ">" The redirection should
be "<" to feed the sql dump file
$ psql mydbName < backupFrompg_dumpFile
> 
> Hope it will helps.
> 
Thanks a lot !!

We'll include a basic backup / restore chapter on the Wikibook with
this info.

Best,
> 
> 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
> >
> >
> >