Back-porting a database?
Well, I've been unable to get PG 7.2 to load on RedHat 7.1 machine.
So, can I load database(s) from one running PG 7.2 into a system running PG
7.1.3? If so, what are the switches on pg_dump or psql to do this?
Here's what I normally do:
pg_dump -U postgres -d -v -f output.sql dbname
psql -e dbname < output.sql
But when I dump from a system running PG 7.2, and try to load on a system
running PG 7.1.3, I get errors.
Thanks,
Ben
Benjamin Smith <bens@benjamindsmith.com> writes:
So, can I load database(s) from one running PG 7.2 into a system running PG
7.1.3? If so, what are the switches on pg_dump or psql to do this?
Get out your editor and fix whatever it is that 7.1 doesn't like about
the schema.
In general, we do not promise backwards compatibility of dumps.
regards, tom lane