[pgpool-hackers: 4114] Re: Failover on starting up

[Tatsuo Ishii]

> Hello
> 
> I have a setup with 1 pgpool and 2 postgresql primary-replica nodes.
> 
> I am testing a certain scenario - what if the pgpool goes down, then the primary goes down and then the pgpool comes back up.
> 
> I was expecting that pgpool would perform a failover after it comes back up but instead it says this:
> 2022-02-04 16:48:53: pid 9: LOG:  Pgpool-II parent process has received failover request
> 2022-02-04 16:48:53: pid 9: LOG:  ignoring the failover request, since we are still starting up
> 
> So my question is, is there a parameter or some way that we can tell pgpool to perform a failover if the primary is down while pgpool is starting up?
> 
> I tried looking at the code but according to https://github.com/pgpool/pgpool2/blob/master/src/main/pgpool_main.c#L1329, I don’t see a parameter other than processState.
> 
> Is there a logical reason why pgpool cannot/won't perform a failover during startup?

Because pgpool needs to setup various resouses including shared memory
and others for managing failover.

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