Skip site navigation (1) Skip section navigation (2)

BUG #7809: Running pg_dump on slave w/ streaming replication fails ifthere 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 ifthere are unlogged tables
Date: 2013-01-14 23:13:14
Message-ID: E1TutDO-0001Hb-2v@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-hackers by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group