Thread: Upgrading to 7.3.4?

Upgrading to 7.3.4?

From
Bjørn T Johansen
Date:
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,

BTJ

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen (BSc,MNIF)
Executive Manager
btj@havleik.no                  Havleik Consulting
Phone : +47 67 54 15 17         Conradisvei 4
Fax : +47 67 54 13 91           N-1338 Sandvika
Cellular : +47 926 93 298       http://www.havleik.no
-----------------------------------------------------------------------------------------------
"The stickers on the side of the box said "Supported Platforms: Windows
98, Windows NT 4.0,
Windows 2000 or better", so clearly Linux was a supported platform."
-----------------------------------------------------------------------------------------------


Re: Upgrading to 7.3.4?

From
Freddy Menjívar M.
Date:
----- 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
 

Re: Upgrading to 7.3.4?

From
"scott.marlowe"
Date:
On 30 Jul 2003, Bjørn T Johansen wrote:

> 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?

If it's on the same box, no need to copy, just run 7.3.4 in 7.3.3's place.


Re: Upgrading to 7.3.4?

From
Paul Ramsey
Date:
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
      \_


Re: Upgrading to 7.3.4?

From
Bjørn T Johansen
Date:
Thanks for all your suggestions, I will be trying this... :)


BTJ

On Thu, 2003-07-31 at 20:27, scott.marlowe wrote:
> On Thu, 31 Jul 2003, Paul Ramsey wrote:
>
> > 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
>
> Actuall, it's a really good idea to do:
>
> make
> pg_ctl stop
> make install
> pg_ctl start
>
> I.e. you shouldn't have a service that's running when you do a 'make
> install'.



Re: Upgrading to 7.3.4?

From
"scott.marlowe"
Date:
On Thu, 31 Jul 2003, Paul Ramsey wrote:

> 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

Actuall, it's a really good idea to do:

make
pg_ctl stop
make install
pg_ctl start

I.e. you shouldn't have a service that's running when you do a 'make
install'.