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 "o

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

2016-05-15 Thread Jay Howard
ng replication in the mean time. On Sat, May 14, 2016 at 8:20 PM, Venkata Balaji N wrote: > > 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 happeni

[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