Re: [Gnumed-devel] Restoring a database under Debian

[Karsten Hilbert]

On Wed, Jan 14, 2015 at 07:38:02PM +0000, Jim Busser wrote:

> > I'll adjust the script to be more resilient. In the meantime
> > please re-run with the _full_ path to the backup file given
> > to the script.
> 
> Closer … inside the Debian (VirtualBox) VM, within my normal user account 
> (jim), I downloaded server 20.0 tarball and then as root, changed into the 
> server directory
> 
>       cd downloads/gnumed-server.20.0/server
> 
> but before proceeding, because I now have postgres 9.1 and 9.4 running in 
> this vm which might cause port confusion, I checked their status …
> 
>       /usr/bin/pg_lsclusters
> 
> giving me
> 
>       Ver Cluster Port Status Owner Data directory Log file
>       9.1 main 5432 online postgres /var/lib/postgresql/9.1/main 
> /var/log/postgresql/postgresql-9.1-main.log
>       9.4 main 5433 online postgres /var/lib/postgresql/9.4/main 
> /var/log/postgresql/postgresql-9.4-main.log 
> 
> and so to ensure that when the restore script calls the right port, I took 
> the precaution of
> 
>       PGPORT=5433; export PGPORT

BTW, is there any specific reason why you are restoring into
PostgreSQL 9.4 ?  IMHO it just complicates things (witness
the need for defining the port).

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346