Re: [GENERAL] tx canceled on standby despite infinite max_standby_streaming_delay

2016-05-15 Thread Jay Howard
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

Re: [GENERAL] tx canceled on standby despite infinite max_standby_streaming_delay

2016-05-15 Thread David G. Johnston
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

Re: [GENERAL] tx canceled on standby despite infinite max_standby_streaming_delay

2016-05-15 Thread Jay Howard
> > 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

Re: [GENERAL] tx canceled on standby despite infinite max_standby_streaming_delay

2016-05-14 Thread Venkata Balaji N
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

[GENERAL] tx canceled on standby despite infinite max_standby_streaming_delay

2016-05-13 Thread Jay Howard
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