----- Original Message -----
From: "Bjørn T Johansen" <btj@havleik.no>
To: <pgsql-general@postgresql.org>
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