Dear pgpool,
I built up a postgresql 17.6.2 3 nodes cluster with 3 pgpool 4.6.2 , when I
try to switch over using “pcp_promote_start -s …..” it seems other standy
nodes can not follow the new primary node. However, after I remove the
“postgres.auto.conf” in each server and switch over using the same command
again, it works. I have also check what store in “postgres.auto.conf”, it
may store many config like “primary_conn_info” which connect to the old
primary.
Do you have any idea about this? Or do you know what mechanism cause
postgres store the old primary info in “postgres.auto.config” file?
Best regards,
Terence