Re: restoring databases with intensive foreign key use - Mailing list pgsql-general

From Stephan Szabo
Subject Re: restoring databases with intensive foreign key use
Date
Msg-id 20020514084856.D27828-100000@megazone23.bigpanda.com
Whole thread Raw
In response to restoring databases with intensive foreign key use fails  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
On Wed, 8 May 2002, Tino Wildenhain wrote:

> Hi,
>
> restoring the database only from pg_dump/pg_restore
> seems to be impossible if one uses foreign keys much.
> The tables referenced are most of the time not available
> by the time the referencing tables are created. Even
> restoring by OID order does not help.

I haven't used any of the custom dump formats, but the text
one should put the constraint information at the bottom after
table and data creation as create constraint trigger statements.
What does your dump look like?



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: transitioning postgres oid
Next
From: tony
Date:
Subject: Re: Using COPY