Re: Upgrading to 7.3.4?

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
      \_