All tables and rules would be the same. I assume with the -a flag, we'd need to create the database and relations beforehand, but that shouldn't be too much trouble. Thanks again, -Pete On 4/8/13 8:46 AM, "Adrian Klaver" <adrian.klaver@xxxxxxxxx> wrote: >On 04/08/2013 06:41 AM, Pete Wall wrote: >> 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. > >You could use the -a (data only) switch to pg_dump: >http://www.postgresql.org/docs/9.2/interactive/app-pgdump.html > >This assumes the table layout is the same in your 9.x and 8.x databases, >also that you have not used any new data types i.e JSON. > >> >> Thanks, Adrian. >> > > > >-- >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
