Re: Migration from 7.1.3. to 7.4.7. - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Migration from 7.1.3. to 7.4.7.
Date
Msg-id 1111420428.26897.51.camel@state.g2switchworks.com
Whole thread Raw
In response to Migration from 7.1.3. to 7.4.7.  ("Dr. Roger Wießner" <wiessner@confluenta.de>)
Responses Re: Migration from 7.1.3. to 7.4.7.  ("Bryan Encina" <bryan.encina@valleypres.org>)
Re: Migration from 7.1.3. to 7.4.7.  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-admin
On Wed, 2005-03-16 at 06:07, Dr. Roger Wießner wrote:
> Can anyone tell me how to successfully migrate from 7.1.3. to 7.4.7.? I get
> lots of errors...

Try to have both installed at once (separate dirs, or separate machines)
and dump the 7.1.3 db with the 7.4.7 pg_dump.  You might want to do a
file system backup and an upgrade of 7.1.3 to the last version of 7.1.3.

On rare occasions, an intermediate upgrade to something in between may
help, but I've not used 7.1 in a VERY long time.

pgsql-admin by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: testing pgpool
Next
From: juanmime@ono.com
Date:
Subject: Resizing images contained in oid fields