On Tue, Jun 7, 2011 at 10:33 PM, A J <s5...@yahoo.com> wrote: > Having a master and 2 slaves in synchronous replication mode in 9.1 > The master seems to wait for only one slave to respond before considering > the transaction to be complete. I have done the setting for master to wait > for all the slaves to finish: > synchronous_standby_names = '*' > I even tried replacing * with both the slave application_names. > Still master just waits for a single slave. Am I doing something incorrect > or is it a limitation ?
No, its a design decision to improve availability and performance. You can list the second standby also, so it can take over in the event of failure. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
