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?
Assuming my replicated databases are on nodes: testqa1, testqa2. What would my synchronous_standby_names entry in my postgresql.conf on my master database?
Regards
John Wiencek