Re: [Gnumed-devel] Solved: Upgrade Postgresql for GNUmed on Windows

[Karsten Hilbert]

On Tue, Nov 19, 2013 at 05:56:55PM +0000, Jim Busser wrote:

> >>>>> 8.) type: pg_dump -p 5432 -Fc -f gnumedv18.backup gnumed_v18
> >>>>> 
> >>>>> 9.) type: pg_dumpall --globals-only > globals.sql
> >>>> 
> >>>> I think the above needs to be
> >>>> 
> >>>>  pg_dumpall -p 5432 --globals-only > globals.sql
> >>> 
> >>> That's safer but not required as 5432 is the default
> >>> port unless reconfigured.
> >> 
> >> As would have been achieved from steps 2-5 taken earlier in the sequence:
> >> 
> >> - in Step 2, self-installation of the new postgres on port 5433 and
> >> 
> >> - in Step 6, SET PATH=%PATH%;C:\Programme\PostgreSQL\9.3\bin
> > 
> > Neither step reconfigures the default port 5432 of
> > PG 8.4 as far as I can see.
> 
> My impression had been that in the process of upgrading, one is supposed to 
> use the new binaries in place of the old ones.
> 
> This seems the case not just for pg_upgrade, but also for pg_dump and 
> pg_dumpall

That's correct. And it's got nothing to do with
the ports in use.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346