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

[Piotr Gbyliczek]

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. 

Regards,
Piotr