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
