Re: synch streaming replication question - Mailing list pgsql-general

From Michael Paquier
Subject Re: synch streaming replication question
Date
Msg-id CAB7nPqTiZTzViBy5WH6HE1pn85pbyAgMxnDquNKF9252Eter=w@mail.gmail.com
Whole thread Raw
In response to Re: synch streaming replication question  (John Wiencek <jwiencek3@comcast.net>)
List pgsql-general
On Tue, Feb 23, 2016 at 12:02 PM, John Wiencek <jwiencek3@comcast.net> 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,*'

This is fine. Thanks to '*', all the other standby nodes connected to
this primary server will be thought as potential synchronous
candidates. And one of them will be. With this configuration keypg2 is
chosen first though if it is connected.
--
Michael


pgsql-general by date:

Previous
From: John Wiencek
Date:
Subject: Re: synch streaming replication question
Next
From: Venkata Balaji N
Date:
Subject: Re: Live steraming replication setup issue!