Re: pg_restore and create FK without verification check

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: ow <oneway_111(at)yahoo(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_restore and create FK without verification check
Date: 2003-11-26 10:35:25
Message-ID: 1069842925.2749.5.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andreas Pflug kirjutas K, 26.11.2003 kell 12:09:
> ow wrote:
>
> >
> >It appears there's not a lot of interest in discussing the possibility of FK
> >constraint creation WITHOUT the verification check. How then should one handle
> >the situation with pg_restore and large dbs where creation of FK constraint(s)
> >may take hours?
> >
> >
>
> I'd prefer a backup/restore method that dumps physical data, so at
> restore time there's no need for recreation of FKs. But I didn't see any
> feedback on this proposal either.

Was this proposal a separate one from using WAL logs for PITR ?

-------------
Hannu

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Pflug 2003-11-26 11:33:28 Re: pg_restore and create FK without verification check
Previous Message Andreas Pflug 2003-11-26 10:09:31 Re: pg_restore and create FK without verification check