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
On Mon, Oct 7, 2024 at 11:04 PM wrote:
> 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 dea
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
