BUG #6176: pg_dump dumps pg_catalog tables
От | Chander Ganesan |
---|---|
Тема | BUG #6176: pg_dump dumps pg_catalog tables |
Дата | |
Msg-id | 201108251300.p7PD0HiL074200@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #6176: pg_dump dumps pg_catalog tables
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 6176 Logged by: Chander Ganesan Email address: chander@otg-nc.com PostgreSQL version: 9.0.4 Operating system: Centos 5.6 Description: pg_dump dumps pg_catalog tables Details: Normally, the pg_dump command ignored the pg_catalog tables when performing a dump. However, when provided the '--table' argument it fails to ignore the pg_catalog table. For example, suppose I had tables p1-p10 that I wanted to dump, I could use the following command: pg_dump test_db --table 'p*' This command would dump the requested tables, but it would also dump all the tables (in all schemas) that start with 'p*' . Generally speaking, there are no "excluded schemas" when using the pg_dump command with the '--table' argument. It is my belief that the pg_catalog tables should almost always be ignored (lest restores fail miserably).
В списке pgsql-bugs по дате отправления: