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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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