public inbox for [email protected]  

help / color / mirror / Atom feed

From: Macao Tom <[email protected]>
To: [email protected]
Subject: About pgpool failover / switchover
Date: Fri, 12 Sep 2025 11:43:07 +0800
Message-ID: <CAPTV4vzgri_2VogHSZUv9-h2+PkWKdAcESg3eOwxkf2MV7UrYQ@mail.gmail.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: About pgpool failover / switchover
  In-Reply-To: <CAPTV4vzgri_2VogHSZUv9-h2+PkWKdAcESg3eOwxkf2MV7UrYQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox