[pgpool-general: 7231] Re: Query regarding failover and recovery

Tatsuo Ishii ishii at sraoss.co.jp
Mon Aug 31 06:34:51 JST 2020

> I'm not sure I am understanding.
> If a old primary node will resume it has to become a new standby if a
> primary was promoted with an automatic failover.
> Let me explain my use case.
> I'm building a new repmgr cluster with one primary and two standbys.
>  During the night dumps of virtual machines are automatically triggered and
> it could happen that one virtual machine could be unavailable for a while
> during the dump. If this happens, Pgpool will make a failover and a standby
> node will become primary. After some minutes the former primary will become
> available again, but it would be a false primary. In this case I'd issue a
> "repmgr node rejoin" command to let it become a new standby.
> I would like this to happen automatically.

I am not fammilar with repmgr. What does "repmgr node rejoin"? Why do
you need repmgr in the first place? Doe it have a feature which
Pgpool-II does not have?

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

More information about the pgpool-general mailing list