This is a minor version upgrade, so data can remain in place. For a 7.2 -> 7.3 upgrade you would have to dump-and-restore.
My upgrade procedure is:
tar xvfz postgresql-7.3.4.tar.gz ; cd postgresql-7.3.4
./configure ; make ; make install
pg_ctl stop ; pg_ctl start
Freddy Menjívar M. wrote:
----- Original Message ----- From: "Bjørn T Johansen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 30, 2003 3:53 PM Subject: [GENERAL] Upgrading to 7.3.4?
> If I upgrade from 7.3.3 to 7.3.4, is it enough to just copy the data
> directory from 7.3.3 to 7.3.4 to "restore" my databases?
> Regards
Try something like this
==============================================
pgdumpall > dbbackup -- backup and stop
pg_ctl stop
mv %PGHOME% /usr/local/pgsql.old -- move old pgsql program
cd /usr/local/src/postgresql-7.3.2 -- installs new pgsql version make install
initdb -D %PGHOME%/data -- start and restore db.
pg_ctl start
psql < dbackup
-- __ / | Paul Ramsey | Refractions Research | Email: [EMAIL PROTECTED] | Phone: (250) 885-0632 \_
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings