public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: kasem adel <[email protected]>
Cc: [email protected]
Subject: Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster
Date: Tue, 07 Jan 2025 07:57:19 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAP-pBm-Y=b6YxHPag0TLertO=7OCo1kN8RVjBg5mvJNx6Y56KA@mail.gmail.com>
References: <CAP-pBm9YJqrZQgrH1ZsFt9RbTsOTKH1niS5bEhhB_mSsT49B5Q@mail.gmail.com>
	<[email protected]>
	<CAP-pBm-Y=b6YxHPag0TLertO=7OCo1kN8RVjBg5mvJNx6Y56KA@mail.gmail.com>

On Tue, 2025-01-07 at 01:59 +0200, kasem adel wrote:
> Dear Laurenz Albe
> في الاثنين، ٦ يناير ٢٠٢٥ ٧:١٣ م Laurenz Albe <[email protected]> كتب:
> > On Sun, 2025-01-05 at 19:57 +0200, kasem adel wrote:
> > > Proposed Upgrade Approach:
> > > 
> > > Simultaneous Upgrade Process:
> > > 
> > > Install new PostgreSQL version packages on both nodes
> > > Run pg_upgrade with --check flag on both nodes
> > > Execute pg_upgrade with --link option on both nodes simultaneously
> > > Update Patroni configuration for new version on both nodes
> > 
> > No, that won't work.
> > 
> > You have to upgrade the primary, then rebuild the standby with
> > "patronictl reinit".  There is no safe way to upgrade the standby.
>
> Our application for reporting  is  dependent on the replica node for handling
> read-only operations. If we proceed with the proposed changes, it would result
> in a one-month application downtime, which would significantly impact our
> operations and is not a feasible option for us.
>
> We would greatly appreciate your insights and support in identifying
> alternative solutions [...]

One month to rebuild a standby?
Before I discuss options, let me ask how you plan to survive the next time you
have to restore your database from a backup.

There are two paths you can consider:
1. Logical replication into a new Patroni cluster.
   That is not simple.

2. Following the steps in
   https://www.postgresql.org/docs/current/pgupgrade.html#PGUPGRADE-STEP-REPLICAS
   to upgrade the standby server.
   That is not for the faint of heart either.

In both cases, you'd have to test the procedure well, and it might be a good idea
to get professional assistance.

Yours,
Laurenz Albe

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: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster
  In-Reply-To: <[email protected]>

* 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