Re: [HACKERS] Primary not sending to synchronous standby

2015-02-26 Thread Thom Brown
On 26 February 2015 at 13:08, Andres Freund wrote: > On 2015-02-23 17:09:24 +, Thom Brown wrote: > > On 23 February 2015 at 16:53, Andres Freund > wrote: > > > Comments? This is obviously just a POC, but I think something like this > > > does make a great deal of sense. > > > > > > Thom, doe

Re: [HACKERS] Primary not sending to synchronous standby

2015-02-26 Thread Andres Freund
On 2015-02-23 17:09:24 +, Thom Brown wrote: > On 23 February 2015 at 16:53, Andres Freund wrote: > > Comments? This is obviously just a POC, but I think something like this > > does make a great deal of sense. > > > > Thom, does that help? > Yeah, this appears to eliminate the problem, at lea

Re: [HACKERS] Primary not sending to synchronous standby

2015-02-24 Thread Andres Freund
On 2015-02-23 17:53:59 +0100, Andres Freund wrote: > On 2015-02-23 15:48:25 +, Thom Brown wrote: > > On 23 February 2015 at 15:42, Andres Freund wrote: > > > > > On 2015-02-23 16:38:44 +0100, Andres Freund wrote: > > > > I unfortunately don't remember enough of the thread to reference it > >

Re: [HACKERS] Primary not sending to synchronous standby

2015-02-23 Thread Thom Brown
On 23 February 2015 at 16:53, Andres Freund wrote: > On 2015-02-23 15:48:25 +, Thom Brown wrote: > > On 23 February 2015 at 15:42, Andres Freund > wrote: > > > > > On 2015-02-23 16:38:44 +0100, Andres Freund wrote: > > > > I unfortunately don't remember enough of the thread to reference it >

Re: [HACKERS] Primary not sending to synchronous standby

2015-02-23 Thread Andres Freund
On 2015-02-23 15:48:25 +, Thom Brown wrote: > On 23 February 2015 at 15:42, Andres Freund wrote: > > > On 2015-02-23 16:38:44 +0100, Andres Freund wrote: > > > I unfortunately don't remember enough of the thread to reference it > > > here. > > > > Found the right keywords. The threads below >

Re: [HACKERS] Primary not sending to synchronous standby

2015-02-23 Thread Thom Brown
On 23 February 2015 at 15:42, Andres Freund wrote: > On 2015-02-23 16:38:44 +0100, Andres Freund wrote: > > I unfortunately don't remember enough of the thread to reference it > > here. > > Found the right keywords. The threads below > > http://archives.postgresql.org/message-id/369698E947874884A

Re: [HACKERS] Primary not sending to synchronous standby

2015-02-23 Thread Thom Brown
On 23 February 2015 at 15:38, Andres Freund wrote: > Hi, > > On 2015-02-23 15:25:57 +, Thom Brown wrote: > > I've noticed that if the primary is started and then a base backup is > > immediately taken from it and started as as a synchronous standby, it > > doesn't replicate and the primary ha

Re: [HACKERS] Primary not sending to synchronous standby

2015-02-23 Thread Andres Freund
On 2015-02-23 16:38:44 +0100, Andres Freund wrote: > I unfortunately don't remember enough of the thread to reference it > here. Found the right keywords. The threads below http://archives.postgresql.org/message-id/369698E947874884A77849D8FE3680C2%40maumau and http://www.postgresql.org/message-id/

Re: [HACKERS] Primary not sending to synchronous standby

2015-02-23 Thread Andres Freund
Hi, On 2015-02-23 15:25:57 +, Thom Brown wrote: > I've noticed that if the primary is started and then a base backup is > immediately taken from it and started as as a synchronous standby, it > doesn't replicate and the primary hangs indefinitely when trying to run any > WAL-generating stateme

[HACKERS] Primary not sending to synchronous standby

2015-02-23 Thread Thom Brown
Hi, I've noticed that if the primary is started and then a base backup is immediately taken from it and started as as a synchronous standby, it doesn't replicate and the primary hangs indefinitely when trying to run any WAL-generating statements. It only recovers when either the primary is restar