BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

From: joe(at)tanga(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables
Date: 2013-01-14 23:13:14
Message-ID: E1TutDO-0001Hb-2v@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

The following bug has been logged on the website:

Bug reference: 7809
Logged by: Joe Van Dyk
Email address: joe(at)tanga(dot)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@ticketevolution.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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message richardbrown360 2013-01-15 00:22:36 BUG #7810: cant uninstall or install program
Previous Message John R Pierce 2013-01-14 22:09:38 Re: BUG #7806: installation failed for postgis on Windows

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2013-01-14 23:29:07 [PATCH] Compile without warning with gcc's -Wtype-limits, -Wempty-body
Previous Message Heikki Linnakangas 2013-01-14 22:49:05 Re: s/size_t/off_t/ in sendTimeLineHistory