--- Andreas Pflug <pgadmin@pse-consulting.de> wrote:
> 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.
>
I think creating a FK without verification check is still needed, especially in
case if:
1) original db is corrupted
2) during cluster upgrade
3) there's a need to BACKUP/RESTORE a *schema* instead of db.
Thanks
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/