[pgpool-general: 4136] Re: Testing pgpool + failover on random servers restarts

Chris Pacejo cpacejo at clearskydata.com
Sat Oct 24 03:49:04 JST 2015


> The problem is that the status file is not updated when the failover and the failback is happening so if the pgpool does not stop properly from the script and I just unplug the server or I kill pgpool the current status is lost and I might end up in a split brain at the database level. I can update the status file in my scripts when a failover or failback occur to preserve the status, but I was currious if that is the right way to do it or I missed something.

I think this was a bug that was fixed a couple months back.  This
scenario works for us, since pgpool now calls write_status_file() on
every failover, rather than just on shutdown.


More information about the pgpool-general mailing list