Hello!
We have a pretty large db (10 G and ~ 100 tables). Sometimes (when somebody deleted something usefull from table) it is necessary to restore only one or two tables from backup.
I've set up daily full database backup (pg_dump -U <user> <db>) and per-table backups (pg_dump -U <user> -t <table> <db>).
The question is about constrains & foreign keys.
It's clear that restoring only one table to yesturday's state may break some foreign keys. Do I need to do some extra things to make restore successfully?
Postgres 8.1.x
--
Vladimir Rusinov
Voronezh, Russia
UNIX Admin @ Murano Software