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.