| From: | K P Manoj <kpmanojpg(at)gmail(dot)com> |
|---|---|
| To: | Michael Banck <mbanck(at)gmx(dot)net> |
| Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: PG version 16.14 upgrade went recovery state |
| Date: | 2026-07-07 05:57:12 |
| Message-ID: | CAMVgnQ4oU9aU42HjVL-dj5J8=2dC3kVesb09SDqGCNcTAyjehw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Dear Michael,
Thank you for your email.
My primary objective is to mitigate CVE-2026-6473, and the required fix is
only available in version 16.14. Therefore, I will wait for the next minor
release.
Regards,
Manoj K P
On Mon, Jul 6, 2026 at 9:32 PM Michael Banck <mbanck(at)gmx(dot)net> wrote:
> On Sun, Jul 05, 2026 at 03:06:48PM +0200, Laurenz Albe wrote:
> > On Fri, 2026-07-03 at 15:25 +0530, K P Manoj wrote:
> > > I am encountering an issue when upgrading our PostgreSQL database from
> minor version 16.10 to 16.14.
> > >
> > > During the upgrade, the database enters an indefinite recovery mode
> across the master, standby,
> > > and multiple cascading replicas. Due to legacy requirements, we are
> utilizing streaming replication
> > > for this setup. Interestingly, when performing the same migration to
> version 16.13, the process
> > > completes successfully without any issues.
> > >
> > > Could you please confirm if there are any known bugs regarding this
> behavior in version 16.14?
> >
> > Yes, this could be bug 19490:
> > https://postgr.es/m/flat/19490-9c59c6a583513b99%40postgresql.org
> >
> > Best wait for 16.15 before updating.
>
> The alternatve is to do a two-step process, where you ugprade everything
> to 16.13, then upgrade the standbys to 16.14. As far as I know, the
> leader needs to be on 16.11 or earlier (while the standbys needs to be
> on 16.4) to hit this bug, so updating it to 16.12 or 16.13 should
> circumvent this as well.
>
> I wrote a blog-post summarizing the issue here:
>
> https://www.credativ.de/en/blog/postgresql-en/replication-deadlock-bug-in-current-postgres-releases-14-16/
>
>
> Michael
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eduar Flow | 2026-07-07 06:11:28 | Re: test |
| Previous Message | Alija Rahmanovic | 2026-07-07 04:29:46 | Re: Any known bugs with respect to data corruption in pg12/pg 14 |