[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