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 [EMAIL PROTECTED]