Re: pg_ [dump & restore] invalid archive problem - Mailing list pgsql-novice

From Tom Lane
Subject Re: pg_ [dump & restore] invalid archive problem
Date
Msg-id 4342.1099602370@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_ [dump & restore] invalid archive problem  ("John-Paul Delaney" <John-Paul.Delaney@wfp.org>)
List pgsql-novice
"John-Paul Delaney" <John-Paul.Delaney@wfp.org> writes:
> Thanks Tom... I'm hoping to move the db from a version 7.3.3 to 7.2.4

Why?

Archive header incompatibility is going to be the *least* of your
worries.  pg_dump output is not designed to be loaded into old versions
without problems, and in this case you are talking about going backwards
over the addition of schemas.  You'll have all kinds of syntax errors.

I can't imagine why you'd be wanting to go back to 7.2.anything anyway.

            regards, tom lane

pgsql-novice by date:

Previous
From: "John-Paul Delaney"
Date:
Subject: Re: pg_ [dump & restore] invalid archive problem
Next
From: "John-Paul Delaney"
Date:
Subject: Re: pg_ [dump & restore] invalid archive problem