Loading pg_dump from 7.2 db >> 7.1 db

From: Benjamin Smith <bens(at)benjamindsmith(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Loading pg_dump from 7.2 db >> 7.1 db
Date: 2002-03-07 05:46:56
Message-ID: 0203062146560L.29432@bug2.benjamindsmith.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Well, I've been unable to get PG 7.2 to load on RH 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

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Smith 2002-03-07 05:51:21 Back-porting a database?
Previous Message Benjamin Smith 2002-03-07 05:43:35 Installing 7.2 on RedHat 7.1