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

[Salman Ahmed]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20230825/07fb4682/attachment.htm>