Re: [GENERAL] synch streaming replication question

2016-02-22 Thread Michael Paquier
On Tue, Feb 23, 2016 at 12:02 PM, John Wiencek wrote: > How do I configure both standbys as ³synch² nodes? > > Do I list both nodenames or ip addresesses in the postgresql.conf > synchronous_standyby_names entry? > > My current entery looks like this: > > synchronous_standby_names = 'keypg2,*' Th

Re: [GENERAL] synch streaming replication question

2016-02-22 Thread John Wiencek
How do I configure both standbys as ³synch² nodes? Do I list both nodenames or ip addresesses in the postgresql.conf synchronous_standyby_names entry? My current entery looks like this: synchronous_standby_names = 'keypg2,*' John On 2/22/16, 8:25 PM, "Thomas Munro" wrote: >On Tue, Feb 2

Re: [GENERAL] synch streaming replication question

2016-02-22 Thread Thomas Munro
On Tue, Feb 23, 2016 at 3:09 PM, Michael Paquier wrote: > On Tue, Feb 23, 2016 at 6:43 AM, John Wiencek wrote: > >> I have a three node cluster using streaming replication configured as >> follows: >> One synch node and one asynch node. >> If my synch node is down the master node is hung until th

Re: [GENERAL] synch streaming replication question

2016-02-22 Thread Michael Paquier
On Tue, Feb 23, 2016 at 6:43 AM, John Wiencek wrote: > I have a three node cluster using streaming replication configured as > follows: > One synch node and one asynch node. > If my synch node is down the master node is hung until that node is brought > back on line. > > Two questions: > 1. Is t

[GENERAL] synch streaming replication question

2016-02-22 Thread John Wiencek
Hi All I have a three node cluster using streaming replication configured as follows: One synch node and one asynch node. If my synch node is down the master node is hung until that node is brought back on line. Two questions: 1. Is this the expected action on my master? It makes sense if