| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | John Wiencek <jwiencek3(at)comcast(dot)net> |
| Cc: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: synch streaming replication question |
| Date: | 2016-02-23 03:15:22 |
| Message-ID: | CAB7nPqTiZTzViBy5WH6HE1pn85pbyAgMxnDquNKF9252Eter=w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Feb 23, 2016 at 12:02 PM, John Wiencek <jwiencek3(at)comcast(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Venkata Balaji N | 2016-02-23 03:20:32 | Re: Live steraming replication setup issue! |
| Previous Message | John Wiencek | 2016-02-23 03:02:06 | Re: synch streaming replication question |