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@gallo.ucsf.edu