From: | "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Dump only part of a DB |
Date: | 2004-06-09 14:09:27 |
Message-ID: | Pine.LNX.4.58.0406091006180.6478@shishi.roaringpenguin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
pg_dump can be used to dump an entire database, or just a single
table. Is there a way to make a consistent dump of more than one
table, but less than all of the tables in the database? Doing a bunch
of single-table pg_dumps isn't really an option, because some tables
may change during the dumps, leading to constraint violations if we
try to restore them.
Rationale: We have an application that makes a nightly dump of its
database. There's one particular table that tends to be large, but happily
it's not critical if it's lost -- no real need to back it up. So we'd
like to back up everything except that one large, non-critical table.
Regards,
David.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Janian | 2004-06-09 14:22:43 | Re: Corrupted or deleted pg_tables |
Previous Message | Tom Lane | 2004-06-09 13:53:32 | Re: Refined LC_COLLATE or multiple database clusters? |