public inbox for [email protected]  

help / color / mirror / Atom feed

From: Michael Banck <[email protected]>
To: Mahesh Sathe <[email protected]>
Cc: Raj <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Major upgrade in patroni cluster
Date: Mon, 6 Jul 2026 12:56:19 +0200
Message-ID: <[email protected];lightning.p46.dedyn.io> (raw)
In-Reply-To: <CAG6Sa9Uz9_WTq7u2Zm6VJaJDvYh-vVbqbwstvARj6CJ7f3EGew@mail.gmail.com>
References: <CAJk5Atax1egLDrB3YUb1+q5kGfyFpMsN0H5djSacL309k5C28Q@mail.gmail.com>
	<CAG6Sa9Uz9_WTq7u2Zm6VJaJDvYh-vVbqbwstvARj6CJ7f3EGew@mail.gmail.com>

Hi,

On Mon, Jul 06, 2026 at 04:06:13PM +0530, Mahesh Sathe wrote:
> For a 3-node Patroni cluster with PostgreSQL 17.10, here is the
> high-level approach I typically follow for a major version upgrade to
> 18.4 with minimal downtime.

> High-Level Strategy
>    2. *Upgrade Execution (Minimal Downtime)*:
>       - *Rolling Upgrade*: Utilize Patroni’s rolling upgrade capability.
>       You can upgrade one replica at a time by stopping the Patroni service,
>       upgrading the PostgreSQL binaries, and restarting.

I think you issued the wrong prompt here, because the AI answer
describes a rolling minor-version upgrade.

You cannot run a major-version upgrade on a standby.

The proper high-level procedure is to run pg_upgrade on the leader and
to re-build the standbys afterwards, either through re-clone or via
rsync (see my other message).

In terms of Patroni, one also needs to make sure the DCS configuration
is updated, usually by removing it from DCS and letting Patroni recreate
it.

In general, the procedure is quite well described in the Patroni
documentation here:

https://patroni.readthedocs.io/en/latest/existing_data.html#major-upgrade-of-postgresql-version


Michael

view thread (5+ messages)

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], [email protected]
  Subject: Re: Major upgrade in patroni cluster
  In-Reply-To: <[email protected];lightning.p46.dedyn.io>

* 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