I unintentionally installed 8.4beta2 on a server (using yum), while I
run 8.3.7 on my dev machine.
The 8.3 version of pg_dump does not work with the server, even with
the -i option:
8.3: pg_dump: Error message from server: ERROR: column
"reltriggers" does not exist
the 8.4 pg_dump works okay, but then the 8.3 version of pg_restore is
not able to restore the resultant databases:
8.3: pg_restore: [archiver] input file does not appear to be a
valid archive
How can I migrate a database from 8.4 to 8.3?
I can't see any versioning options in pg_dump:
http://www.postgresql.org/docs/8.4/static/app-pgdump.html
Thanks!