Re: recovery.signal not cleaned up when both signal files are present - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: recovery.signal not cleaned up when both signal files are present
Date
Msg-id CAHGQGwGkwXMmL802fUH=P09bNZBtBwNhbutA+KFxObZPPMQQvQ@mail.gmail.com
Whole thread
In response to Re: recovery.signal not cleaned up when both signal files are present  (Michael Paquier <michael@paquier.xyz>)
Responses Re: recovery.signal not cleaned up when both signal files are present
List pgsql-hackers
On Tue, Feb 10, 2026 at 8:37 AM Michael Paquier <michael@paquier.xyz> wrote:
>
> On Tue, Feb 10, 2026 at 12:41:48AM +0900, Fujii Masao wrote:
> > +1 on also cleaning up recovery.signal when both signal files are present.
> >
> > The documentation states that standby.signal takes precedence if both
> > files exist,
> > and this configuration is not described as unacceptable. So, it doesn't seem ok
> > to prevent the server from starting in this case.
>
> If both are present, startup should be OK and we should be in standby
> mode.  Like reported, it really sounds like a problem to me to enforce
> unnecessary TLI jumps because a recovery.signal is still around after
> a standby promotion.  So, yes, removing it would be a good thing.
> However I would argue against a backpatch as there is a risk of
> slightly breaking existing recovery flows as well.  Doing such a
> change like that on HEAD is OK.  This area of the code has always been
> really sensitive to deal with in stable branches, particularly slight
> changes in recovery behavior that could damage deployments (aka
> monitoring) after a minor version upgrade.

+1 to apply this change only to the master branch. Patch attached.

Regards,

--
Fujii Masao

Attachment

pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: jsonb subscripting vs SQL/JSON array accessor semantics (SQL:2023)
Next
From: Michael Paquier
Date:
Subject: Re: Add expressions to pg_restore_extended_stats()