[pgpool-general: 358] Multiple pgpool servers failover

[Lou Kamenov]

Hey there,

I have been looking at a setup which includes couple of pgpool servers
and about four PostgreSQL nodes in a 1 master, 3 slaves streaming
replication configuration.

>From what I've seen PgPool performs the fallback to backend1 the
moment the master disappears, but in case of two pgpool nodes which
point to the same set of servers, what would the behavior be?

In effect, the first pgpool that detects the failing master will do
the switch and trigger the slave into master mode, what would the
other pgpool do, attempt to trigger backend1 into master mode as well?
will it detect that the master was already triggered, etc.

I will be trying this in practice but would be great to hear other
peoples experience.

Thanks in advance!
Lou