Re: Synchronous replication

On 01/13/2016 12:28 PM, jwiencek3@comcast.net wrote:
> Is it possible to set up synchronous replication to more that one node
> in a cluster?  Or, am I limited to one synchronous node and one
> asynchronous node?

Yes you can have N number of synchronous slaves. However, be careful. It
can be a huge performance hit.

>
> Assuming my replicated databases are on nodes:   testqa1, testqa2.  What
> would my synchronous_standby_names entry in my postgresql.conf on my
> master database?

The IP address that each is binding to.

JD
--
Command Prompt, Inc.                  http://the.postgres.company/
                      +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.