On 01/13/2016 12:28 PM, jwiencek3@xxxxxxxxxxx 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
