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

[Igor Yurchenko]

Hi Tatsuo

I was sure that there is a respective configuration option that makes
"autoattaching" for standby nodes, if replication between nodes works well.

What's a reason to keep a well functioning node in a detached state?

On Sun, 20 Aug 2023, 6:52 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
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20230825/1d0940b6/attachment.htm>