[pgpool-general: 8844] Re: What criteria is for a `failover` and what for a `recovery`?

Bo Peng pengbo at sraoss.co.jp
Mon Jun 19 11:58:52 JST 2023


Hi,

> Hi Bo!
> 
> I am still confused about what to trigger 'recovery' script:
> 
> Is it triggered on pgpool to detect that there is a postgresql server on a
> previously  failed host running on the default port?
> Or it will not wait until such a server resumes running, but initiate
> recovery_1st again and again until finally it succeeds?
> These are totally different.

I think you may be misunderstanding "online recovery".
Pgpool-II doesn't have the functionality to automatically 
recover a failed node and attach it to cluster.

The recovery scripts (1st stage and 2nd stage) are only triggered
when you manually run the pcp_recovery_node command.
And "2nd stage" are only requied for native replication mode and
snapshot isolation mode.

https://www.pgpool.net/docs/latest/en/html/pcp-recovery-node.html

-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/



More information about the pgpool-general mailing list