Dear Postgres gurus, I come seeking advice on upgrading my 8.1.2 databases to 8.2. My environment in a nutshell: I have a master database on one server that is used to process large amounts of data. This data is replicated daily to several destination databases, each on a separate server. There are so many destinations that I fear I won't be able to upgrade them all in one evening. Does anyone know if it would be safe to upgrade a subset of the databases per night? I am concerned with version mismatches between dmp files, pg_restore, and destination database versions. Should the pg_restore still work ok? And if that is ok, should the master database be upgraded in any particular order (before or after the destinations)? I would greatly appreciate any advice that can be offered. Thanks! Mark
