[pgpool-hackers: 4386] Re: Load balancing after failover not working in 3-node HA PostgreSQL cluster

[Tatsuo Ishii]

Glad to hear that. Thank you!
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

> Dear Tatsui Ishii,
> 
> Thank you so much for the support, because of your hint about
> pcp_attach_node we have resolved our issue. We appreciate your support!
> 
> Salman Ahmed
> Stormatics
> 
> 
> On Sun, Aug 20, 2023 at 8:52 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> > Then there's something wrong in your follow primary script. To debug
>> > it, I suggest to look into pgpool log and the standby's PostgreSQL
>> > log. I suspect the standby server failed to follow the new standby for
>> > some reason (maybe some WAL files are missing?). In general you should
>> > fall back to use pg_rewind/pg_base_backup to sync with the new primary
>> > in this case.
>> >
>> > See the official sample script for more details.
>> >
>> >
>> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=blob_plain;f=src/sample/scripts/follow_primary.sh.sample;hb=refs/heads/V4_4_STABLE
>>
>> One thing I noticed is, after reloading PostgreSQL, the script does
>> not execute pcp_attach_node. You need to execute the command because
>> without the command, the standby status keeps on "down" from pgpool's
>> point of view.
>>
>> Best reagards,
>> --
>> Tatsuo Ishii
>> SRA OSS LLC
>> English: http://www.sraoss.co.jp/index_en/
>> Japanese:http://www.sraoss.co.jp
>>