Voot! Not necessary! :)
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" <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
>
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey@refractions.net
| Phone: (250) 885-0632
\_