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

[Tatsuo Ishii]

But after starting up pgpool will detect that the primary went down by
health check and perform failover anyway, no?

> Thank you Tatsuo for your reply but can’t pgpool setup the other resources regardless of the primary being up and then perform the failover?
> 
> I need this behaviour because I cannot pgpool in cluster mode due to infrastructure limitations.
> 
> Cheers
> 
> Anirudh
> On 6 Feb 2022, 1:51 AM +0100, Tatsuo Ishii <ishii at sraoss.co.jp>, wrote:
>> > 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