Re: Upgrading from 7.1.3 to 7.2.3

"Aurangzeb M. Agha" <aagha(at)bigfoot(dot)com> writes:
> I'm ready to do the upgrade anyway possible, using pg_upgrade, not using
> it, whatever.

My suggestion would be to:

(1) Start up the 7.1 postmaster

(2) Make a plaintext dump of your databases using pg_dumpall

(3) Shutdown 7.1, remove the 7.1 RPMs

(4) Download the 7.2 source, compile and install it

(5) Run the 7.2 initdb

(6) Load the 7.1 dump file into your new db using 'psql -f
...'

There are plenty of variations on this -- see the documentation here:

http://developer.postgresql.org/docs/postgres/migration.html

Cheers,

Neil

--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC