Re: restoring databases with intensive foreign key use

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Tino Wildenhain <tino(at)wildenhain(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: restoring databases with intensive foreign key use
Date: 2002-05-14 15:50:39
Message-ID: 20020514084856.D27828-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joel Burton 2002-05-14 16:16:05 Re: Question about setval() function
Previous Message tony 2002-05-14 15:49:20 Re: Using COPY