Re: Restoring 8.2 to 8.0 - Mailing list pgsql-general

From Tom Lane
Subject Re: Restoring 8.2 to 8.0
Date
Msg-id 25096.1180737657@sss.pgh.pa.us
Whole thread Raw
In response to Re: Restoring 8.2 to 8.0  (Robert Fitzpatrick <lists@webtent.net>)
List pgsql-general
Robert Fitzpatrick <lists@webtent.net> writes:
> I have a dump from 8.2 restored to file that was pg_dump'd with format c
> from a production server. I want to know if it is possible for me to
> restore this to a 8.0 development server where I am not able to upgrade
> at this time.

I don't think you'll have much alternative but to manually edit the dump
file.  If I were you I'd dump the schema as text, hack it until it
loads, then do a data-only dump in Fc or whatever format you want.

FWIW the specific errors you're mentioning have to do with SERIAL
columns, so if that's all you're seeing then it should be a pretty
simple set of edits.

You might want to divvy up the schema into stuff to apply before the
data load and stuff to apply after --- indexes and foreign keys go in
the latter set.  See the performance tips about "populating a database".

            regards, tom lane

pgsql-general by date:

Previous
From: Madison Kelly
Date:
Subject: High-availability
Next
From: Jeff Davis
Date:
Subject: Re: Slightly OT.