BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables
От | joe@tanga.com |
---|---|
Тема | BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables |
Дата | |
Msg-id | E1TutDO-0001Hb-2v@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #7809: Running pg_dump on slave w/ streaming
replication fails if there are unlogged tables
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 7809 Logged by: Joe Van Dyk Email address: joe@tanga.com PostgreSQL version: 9.2.2 Operating system: Ubuntu Description: = Running pg_dump on a streaming replication slave with a database that has unlogged_tables will fail unless you provide the "--no-unlogged-table-data" option with the following (scary) error: pg_dump: Dumping the contents of table "tracking_import_data" failed: PQgetResult() failed. pg_dump: Error message from server: ERROR: could not open file "base/16388/190326": No such file or directory pg_dump: The command was: COPY public.tracking_import_data (uuid, tracking_number) TO stdout; (this guy encountered the error as well: http://www.postgresql.org/message-id/DE2DE764-307D-4A23-A9A9-6608AC0977CB@t= icketevolution.com ) Could running pg_dump against a slave always use the "--no-unlogged-table-data" option? In my case, I had automatic scripts that run pg_dump (without the unlogged option) against the slave, and they failed right after I added an unlogged table for the first time.
В списке pgsql-bugs по дате отправления: