It was the data changes I was concerned about: Any additions/deletions/modifications done on the database while it's using the 9.x binaries that should be brought back if we downgrade to the 8.x version. I think the only way would be to "manually" dump the data using custom psql commands instead of using pg_dump/pg_dumpall. Thanks, Adrian. On 4/5/13 6:35 PM, "Adrian Klaver" <adrian.klaver@xxxxxxxxx> wrote: >On 04/05/2013 03:33 PM, Pete Wall wrote: >> Is it possible to downgrade PostgreSQL by a major version? >> >> If I want to upgrade a PG database from 8.x to 9.x, I have to dump the >> db, install the new binaries and import the dump file. This works fine >> going forward, but what if I need to rollback my changes? I cannot dump >> the 9.x database and import it with 8.x binaries, because the 9.x dump >> contains keywords that the old binaries don't understand (e.g. >>REPLICATION). >> >> I could import the original 8.x dump file again, but then I've lost any >> changes made when using the new binaries. > >What changes, data/schema or both? > >> >> Is there a supported way to downgrade PostgreSQL by major versions? > >Not that I know of. > >> >> Thank you, >> -Pete > > >-- >Adrian Klaver >adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
