Skip site navigation (1) Skip section navigation (2)

Sync replication waits for only 1 slave

From: A J <s5aly(at)yahoo(dot)com>
To: PG Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Sync replication waits for only 1 slave
Date: 2011-06-07 21:33:53
Message-ID: 488118.23133.qm@web120004.mail.ne1.yahoo.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-admin by date

Next:From: Simon RiggsDate: 2011-06-07 22:07:10
Subject: Re: Sync replication waits for only 1 slave
Previous:From: Simon RiggsDate: 2011-06-07 19:46:47
Subject: Re: Switchover of Master and Slave roles

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group