Thread: 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