What I mean is if I do pg_dump on slave I get the ERROR: canceling
statement due to conflict with recovery.
So I googled and tried the solution listed in the linked thread.
I did a start transaction via psql on the master but I continued to get
the error.
Wondered if there was more to it than
What is your max_standby_streaming_delay set at?
If your pg_dump takes longer than your max_standby_streaming_delay (which
is likely since the default is 30s), you might get that error as well. This
setting tells your standby how long it should wait to apply conflicting WAL
files to finish a
I would just like to get some clarification from the list on how to do a
pg_dump on the slave in the face of canceling statement due to conflict
with recovery.
The following links seem to indicate that If I start an idle transaction on
the master I should be able to do the pg_dump, but I tried
On Thu, May 12, 2011 at 11:26:38AM -0700, bubba postgres wrote:
I would just like to get some clarification from the list on how to do a
pg_dump on the slave in the face of canceling statement due to conflict
with recovery.
The following links seem to indicate that If I start an idle