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,
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."
-----------------------------------------------------------------------------------------------
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.
----- 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
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?
RegardsTry something like this
==============================================pgdumpall > dbbackup -- backup and stop
pg_ctl stop
mv %PGHOME% /usr/local/pgsql.old -- move old pgsql programcd /usr/local/src/postgresql-7.3.2 -- installs new pgsql version
make installinitdb -D %PGHOME%/data -- start and restore db.
pg_ctl start
psql < dbackup
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey@refractions.net
| Phone: (250) 885-0632
\_
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'.
Thanks for all your suggestions, I will be trying this... :)
BTJ
Show quoted text
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 startActuall, it's a really good idea to do:
make
pg_ctl stop
make install
pg_ctl startI.e. you shouldn't have a service that's running when you do a 'make
install'.