On Sun, May 15, 2016 at 6:15 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> Its customary to bottom-post (or respond inline) on these lists.
>
> On Sun, May 15, 2016 at 7:01 PM, Jay Howard
> wrote:
>
>> Do you have hot_standby_feedback set to "on" ?
>>>
>>
>> It was off. Will resea
Its customary to bottom-post (or respond inline) on these lists.
On Sun, May 15, 2016 at 7:01 PM, Jay Howard
wrote:
> Do you have hot_standby_feedback set to "on" ?
>>
>
> It was off. Will research that. Thank you!
>
> What is the parameter max_standby_archive_delay configured to ? This will
>
> Do you have hot_standby_feedback set to "on" ?
>
It was off. Will research that. Thank you!
What is the parameter max_standby_archive_delay configured to ? This will
> pause WAL archives from being applied when queries are executed on the
> standby database.
>
It's set to the default, whi
On Sat, May 14, 2016 at 12:27 PM, Jay Howard
wrote:
> I'm seeing long-running transactions (pg_dump) canceled on the standby
> when there are a lot of inserts happening on the master. This despite my
> having set max_standby_streaming_delay to -1 on the standby.
>
Do you have hot_standby_feedba
I'm seeing long-running transactions (pg_dump) canceled on the standby when
there are a lot of inserts happening on the master. This despite my having
set max_standby_streaming_delay to -1 on the standby.
Why might that happen?
This is pg 9.3.12. When it happens I see:
pg_dump: Dumping the con