Dump only part of a DB
От | David F. Skoll |
---|---|
Тема | Dump only part of a DB |
Дата | |
Msg-id | Pine.LNX.4.58.0406091006180.6478@shishi.roaringpenguin.com обсуждение исходный текст |
Ответы |
Re: Dump only part of a DB
Re: Dump only part of a DB |
Список | 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.
В списке pgsql-admin по дате отправления: