On Wed, 18 Jun 2008, Andrew Sullivan wrote:
Can't do it. Start the old postmaster with -D /usr4/pgsql_old/data, and then use pg_dumpall against that backend.
Andrew, When I try, I see: postgres@salmo:/var/lib/pgsql$ postgres -D /usr4/pgsql_old/data FATAL: database files are incompatible with server DETAIL: The data directory was initialized by PostgreSQL version 8.1, which is not compatible with this version 8.3.3. Am I correct that the 8.1.4 executables have been replaced with the 8.3.3 ones during the upgrade? Perhaps I should restore /var/lib/pgsql/data from the backup tape, as well as /usr/share/postgresql/, /usr/include/postgresql/, and /usr/bin/postgres? Thanks, Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
