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.
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 |
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 |