Re: [GENERAL] synch streaming replication question

2016-02-22 Thread John Wiencek
<thomas.mu...@enterprisedb.com> wrote: >On Tue, Feb 23, 2016 at 3:09 PM, Michael Paquier ><michael.paqu...@gmail.com> wrote: >> On Tue, Feb 23, 2016 at 6:43 AM, John Wiencek <jwienc...@comcast.net> >>wrote: >> >>> I have a three node cluster using stream

[GENERAL] repmgr faiover question

2016-02-22 Thread John Wiencek
Hello I have a three node postgresql 9.4 cluster configured with one standby in sync mode and the other in asynch mode. If the master datbase is shutdown the pg promote happens as expected. However on the remaining standby node the RECOVERY.CONF file is misconfigured when issuing the command:

[GENERAL] synch streaming replication question

2016-02-22 Thread John Wiencek
if it is since the master is waiting for an ack from the synch node. 2. Is there anyway to configure my cluster so I have a synch node but not have my master node ³HANG² if the synch node is down? Regards John Wiencek

Re: [GENERAL] Synchronous replication

2016-01-13 Thread John Wiencek
Thank you all for the quick replies. John Wiencek On 1/13/16, 2:43 PM, "Thomas Munro" <thomas.mu...@enterprisedb.com> wrote: >On Thu, Jan 14, 2016 at 9:34 AM, Joshua D. Drake <j...@commandprompt.com> >wrote: >> On 01/13/2016 12:28 PM, jwienc...@comcast.net wr