| From: | "Vladimir Rusinov" <vladimir(at)greenmice(dot)info> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | by-table dumps & restore |
| Date: | 2008-02-22 08:39:20 |
| Message-ID: | f6fdfb550802220039j5a47b76cgc83bf93be7cf92f1@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mikko Partio | 2008-02-22 11:05:55 | Stray autovacuum daemon |
| Previous Message | if | 2008-02-22 07:57:41 | Re: vaccuming very large table problem |