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(at)ticketevolution(dot)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

• Re: BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables at 2013-01-15 21:35:36 from Magnus Hagander

pgsql-hackers by date

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

pgsql-bugs by date

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