public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bo Peng <[email protected]>
To: Luca Ferrari <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: main vs primary
Date: Thu, 31 Jul 2025 12:43:19 +0000
Message-ID: <TYWP286MB2633013F06BD8698A8DF18D2F227A@TYWP286MB2633.JPNP286.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAKoxK+7MA9WMKfnnJV29qc4n3aqQ=kWZvGZyd6YafOBtgqvtxw@mail.gmail.com>
References: <CAKoxK+7ZbtVu6WEPtLze+HciX6S8aiRNhqQwD3R=CdwHdYQTRQ@mail.gmail.com>
	<TYWP286MB2633D3F688B88656A74356EEF224A@TYWP286MB2633.JPNP286.PROD.OUTLOOK.COM>
	<CAKoxK+7MA9WMKfnnJV29qc4n3aqQ=kWZvGZyd6YafOBtgqvtxw@mail.gmail.com>

Hi,

Thank you for the update.

I have lool into <https://github.com/pgpool/pgpool2/issues/118;.
I think this issue might be caused by the setting "failover_when_quorum_exists = off".
I will verify the behavior and get back to you with feedback.

________________________________________
差出人: Luca Ferrari <[email protected]>
送信: 2025 年 7 月 31 日 (木曜日) 17:58
宛先: Bo Peng <[email protected]>
Cc: [email protected] <[email protected]>
件名: Re: main vs primary


On Wed, Jul 30, 2025 at 12:03 PM Bo Peng <[email protected]> wrote:
>
> Hi,
>
> The "primary node" refers to the PostgreSQL primary server in a streaming replication setup.
> The "main node" indicates the main backend node, usually the first live backend (i.e., the one with the smallest node ID).

Thanks, much more clear now.

>
> > LOG:  failover: 2 follow backends have been degenerated
> > LOG:  failover: set new primary node: 1
> > LOG:  failover: set new main node: 2
> >
> > in my scenario, the third host (so number 2) has been promoted. So
> > what is the "primary" node 1 doing?
>
> If node2 is promoted to the primary, the primary node should be shown as "node: 2".
> Could you share more logs related to the failover, as well as your configuration file?
>

This is something I'm fighting from days. I've an open issue, updated
almost daily, I don't think repeating all the infor here is
appropriate but I could open a new thread if you believe it is worth.
See <https://github.com/pgpool/pgpool2/issues/118;.
In short: I've three nodes, I shutdown the first and the second gets
promoted. Failover and follow primary are fine, watchdog is happy.
Then I stop the second node, expecting the third to be promoted, and
this happens in fact. But pgpool stops working, and pcp reports the
third node as "standby primary", not "primary primary".
In particular, see behavior in
<https://github.com/pgpool/pgpool2/issues/118#issuecomment-3138977151;.

Any help is appreciated.

Thanks,
Luca

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], [email protected]
  Subject: Re: main vs primary
  In-Reply-To: <TYWP286MB2633013F06BD8698A8DF18D2F227A@TYWP286MB2633.JPNP286.PROD.OUTLOOK.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