pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSync replication waits for only 1 slave
2+ messages / 2 participants
[nested] [flat]
* Sync replication waits for only 1 slave
@ 2011-06-07 21:33 A J <s5aly@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: A J @ 2011-06-07 21:33 UTC (permalink / raw)
To: pgsql-admin
Hello
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 ?
Thanks.
AJ
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Sync replication waits for only 1 slave
@ 2011-06-07 22:07 Simon Riggs <simon@2ndQuadrant.com>
parent: A J <s5aly@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Simon Riggs @ 2011-06-07 22:07 UTC (permalink / raw)
To: A J <s5aly@yahoo.com>; +Cc: pgsql-admin
On Tue, Jun 7, 2011 at 10:33 PM, A J <s5aly@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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-06-07 22:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-06-07 21:33 Sync replication waits for only 1 slave A J <s5aly@yahoo.com>
2011-06-07 22:07 ` Simon Riggs <simon@2ndQuadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox