Re: Upgrading to 7.3.4?

----- Original Message -----
From: "Bjørn T Johansen" <btj(at)havleik(dot)no>
To: <pgsql-general(at)postgresql(dot)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