Re: pg_restore and create FK without verification check

Hannu Krosing wrote:

>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 ?
>
>

Yes, I mentioned it just a few days when discussing dependency in pg_dump.
This is somewhat complementary to WAL and PITR. I'm seeking for a fast
way to dump and restore a complete database, like physical file copy,
without shutting down the backend. I was thinking of a BACKUP command
that streams out the files including any indexes and non-vacuumed
tuples. A database recreated from that wouldn't be as clean as a
pg_dump/pg_restored database, but it would be up much faster, and there
wouldn't be any dependency problem.
This doesn't really replace pg_dump/pg_restore, because it probably
wouldn't be able to upgrade a cluster. Still, it would be helpful for
disaster recovery.

Regards,
Andreas