Among PostgreSQL instances there is only one master. But yes, each server may
be considered master by the clients because it's Pgpool-II will redirect write
queries to the actual master. Maybe it's even better to avoid this unnecessary
traffic between servers and decide which Pgpool-II is in fro
Hello. I have a PostgreSQL high availability cluster with Pgpool-II, but I
don't use the virtual IP feature so my clients don't know which node to send
queries to. DNS round-robin is not a solution because it can't distinguish
between healthy and dead nodes.
I thought about having a Pgpool-II i