[pgpool-hackers: 3360] Behavior of resigned master watchdog node

Tatsuo Ishii ishii at sraoss.co.jp
Fri Aug 2 14:25:26 JST 2019


Hi Usama,

In your commit:
https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=33df0d33df1ce701f07fecaeef5b87a2707c08f2

"the master watchdog node should resign from master responsibilities
if the primary backend node gets into quarantine state on that."

While testing this feature, I noticed that the master watchdog node
resign from master responsibilities as expected in this case. However
none of standby nodes gets promoted to new primary. As a result,
there's no primary node any more after the master watchdog resign.

This is not very good because users cannot issue write queries
anymore. Is this intended?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-hackers mailing list