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.