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

[Tatsuo Ishii]

> 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