[pgpool-general: 4610] Re: Synchronous Streaming replication

Piotr Gbyliczek piotr.gbyliczek at reconnix.com
Mon Apr 4 16:50:26 JST 2016

On Tuesday 29 March 2016 09:51:44 Jose Baez wrote:
> Hi, everyone!
> In a synchronous Streaming replication (activating "
> *synchronous_standby_names*" in PostgreSQL 9.4 or higher)  is there any
> solution/workaround to handle a standby server disconnection and keep
> working with the master node?

Not in system with only two servers. That is the principle of synchronous 
replication, as Lucas pointed out. 

However, if you add second slave to the system, you can list it's name in 
synchronous_standby_names parameter and it becomes a potential. 

That means if you synchronous slave is not available, the potential 
synchronous slave is used. 

That way you are not loosing write capabilities on master. 

Hope this helps. 


More information about the pgpool-general mailing list