[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.
Regards,
Piotr
More information about the pgpool-general
mailing list