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

From Hannu Krosing
Subject Re: pg_restore and create FK without verification check
Date
Msg-id 1069842925.2749.5.camel@fuji.krosing.net
Whole thread Raw
In response to Re: pg_restore and create FK without verification check  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: pg_restore and create FK without verification check  (Andreas Pflug <pgadmin@pse-consulting.de>)
List 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



pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: pg_restore and create FK without verification check
Next
From: Andreas Pflug
Date:
Subject: Re: pg_restore and create FK without verification check