[pgpool-general: 9220] Re: Load balancing of write queries among health-checked nodes

Tatsuo Ishii ishii at postgresql.org
Thu Oct 10 23:11:50 JST 2024


>> Then the clients should avoid to connect to pgpool#3. Instead, connect
>> to #1 or #2.  Unfortunately currently there's no way to make this
>> happen automatically.
> 
> I can use firewall to block incoming connections on the failed Pgpool
> instance, but is there any *_command in pgpool.conf that is executed
> in this case?

At this point, no. Or maybe we should have a new config parameter
which commit sucide the pgpool instance when the it loses the quorum?

By the way, why can't you use VIP?
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list