Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore and create FK without verification check - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: pg_restore and create FK without verification check
Date
Msg-id 3FC47BDB.9060404@pse-consulting.de
Whole thread Raw
In response to pg_restore and create FK without verification check  (ow <oneway_111@yahoo.com>)
Responses Re: pg_restore and create FK without verification check  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
Tree view 
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.

Regards,
Andreas

pgsql-hackers by date:

Previous
From: Hans-Jürgen Schönig
Date:
Subject: statistics about tamp tables ...
Next
From: Hannu Krosing
Date:
Subject: Re: pg_restore and create FK without verification check