Re: pg_dump on 7.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rose, Juergen" <Juergen(dot)Rose(at)sag(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump on 7.4
Date: 2006-05-26 17:47:21
Message-ID: 27489.1148665641@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Rose, Juergen" <Juergen(dot)Rose(at)sag(dot)de> writes:
> We have a running postgresql 7.4 on our server (SuSE Linux 9), and at the moment there is no chance to upgrade. Through an unusual combination of constraints (spanning over schemas) the dump cannot be imported without errors anymore.

Try using an 8.0 or 8.1 pg_dump with the 7.4 server. 7.4's pg_dump is
not very bright about dumping things in the right order. If it still
doesn't work with a modern pg_dump, please show details.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message P.M 2006-05-26 18:00:32 Re: move from 1 database to another
Previous Message David Fetter 2006-05-26 17:21:12 Re: Syntax question