| From: | Stuart Bishop <stuart(at)stuartbishop(dot)net> |
|---|---|
| To: | "List, Postgres" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Failing backups, canceling statement due to conflict with recovery |
| Date: | 2013-02-13 08:53:33 |
| Message-ID: | CADmi=6MrdsBDngu3EEz=-Y71nyPeVUBOBgzJPmE+GGxR1ZuAfw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi.
I'm unable to offload my backups to one of my PG 9.1 hot standbys
using purely streaming replication. After a few hours, usually on the
same large table, pg_dump is failing with 'ERROR: canceling statement
due to conflict with recovery'.
From my reading from the documentation, this should not be possible as
my hot standby has 'hot_standby_feedback = on' in its postgresql.conf.
I submitted a bug report a while ago, but am still unsure if this
option has never worked as intended or if I'm misinterpreting the
documentation.
My goal is to reliably make pg_dump backups from a hot standby without
the hot standby lagging far behind the master.
--
Stuart Bishop <stuart(at)stuartbishop(dot)net>
http://www.stuartbishop.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2013-02-13 10:30:11 | Re: PG V9 on NFS |
| Previous Message | Magnus Hagander | 2013-02-13 08:51:49 | Re: Guidance on building Foreign Data Wrapper on Windows. |