Re: pg_restore - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore
Date
Msg-id 8207.1005182866@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Peter Eisentraut <peter_e@gmx.net> writes:
> No.  You could try the 7.1 pg_dump/pg_restore with 7.0, but it probably
> won't work.

Actually I believe 7.1.1 and later pg_dump *is* backwards compatible
with a 7.0.* server.  The output script isn't, but it should be possible
to use the newer pg_dump to dump out your 7.0 database in preparation
for upgrading.

Not sure how well tested that mode is, mind you, but it's alleged to
work.  I'd recommend running some experiments before trusting it
completely.  (If you can load a schema-only dump of your 7.0 database
into a 7.1 test installation, and everything looks okay, that's probably
enough testing.)

            regards, tom lane

pgsql-general by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: ODBC and Native error codes
Next
From: Hiroshi Inoue
Date:
Subject: Re: LIKE predicate and '\' character