[pgpool-general: 9217] Re: Load balancing of write queries among health-checked nodes
me+pgpool at kotovalexarian.com
me+pgpool at kotovalexarian.com
Thu Oct 10 17:20:19 JST 2024
>> or it may
>> test whether the Pgpool instance is detached from the cluster? Of
>> course libpq doesn't know about Pgpool, it just uses the PostgreSQL
>> protocol, but in case of a detached Pgpool instance will an SQL
>> statement fail with such an error message so that libpq will try the
>> next host?
>
> What do you mean by "detached Pgpool instance"? It is possible to
> detach PostgreSQL instance from pgpool but there's no such an
> operation to detach pgpool.
I mean that it is not in the quorum. For example, we have 3 Pgpool
instances, the client has connectivity with all of them, but Pgpool #3
doesn't have connectivity with Pgpool #1 and #2. So the quorum consists
of #1 and #2, and #3 should consider itself as dead and not allow to
perform any SQL query.
More information about the pgpool-general
mailing list