Re: pg_ [dump & restore] invalid archive problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "John-Paul Delaney" <John-Paul(dot)Delaney(at)wfp(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_ [dump & restore] invalid archive problem
Date: 2004-11-04 21:06:10
Message-ID: 4342.1099602370@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"John-Paul Delaney" <John-Paul(dot)Delaney(at)wfp(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message John-Paul Delaney 2004-11-05 05:36:36 Re: pg_ [dump & restore] invalid archive problem
Previous Message John-Paul Delaney 2004-11-04 20:49:25 Re: pg_ [dump & restore] invalid archive problem