Skip site navigation (1) Skip section navigation (2)

8.3.0 upgrade, confused by documentation

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: 8.3.0 upgrade, confused by documentation
Date: 2008-02-11 18:53:25
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C0378F06F@egcrc-ex01.egcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Everybody,

I am a bit confused by reading documentation
for 8.3.0 upgrade:
http://www.postgresql.org/docs/8.3/interactive/install-upgrading.html

It says:
  1. If making a backup, make sure that your database is
     being updated.
     ...
     To make the backup, you can use the pg_dumpall command
     from the version you are currently running. For best
     results, however, try to use the pg_dumpall command
     from PostgreSQL 8.3.0, since this version contains bug
     fixes and improvements over older versions.

     While this advice might seem idiosyncratic since you
     haven't installed the new version yet, it is advisable
     to follow it if you plan to install the new version in
     parallel with the old version. In that case you can
     complete the installation normally and transfer the
     data later. This will also decrease the downtime.

  ...

  8. Finally, restore your data from backup with

     /usr/local/pgsql/bin/psql -d postgres -f outputfile

     using the new psql


I am going from 8.2.4 to 8.3.0.  Does, "For best results,
however, try to use the pg_dumpall command from PostgreSQL
8.3.0" apply to me?  Doesn't this only apply if one is
already running 8.3.x?  (Even that is a bit strange, since
the last minor rev number is only 0 at this time...)

Assuming I am wrong (ie., what it says does apply to me),
where in the steps (after 4 and before 8) do I make the
backup?

I'd appreciate someone to de-confuse me.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu



Responses

pgsql-admin by date

Next:From: Chander GanesanDate: 2008-02-11 19:47:06
Subject: Re: 8.3.0 upgrade, confused by documentation
Previous:From: Tom LaneDate: 2008-02-11 17:14:59
Subject: Re: can't connect with md5 encrypted pw

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group