public inbox for [email protected]  

help / color / mirror / Atom feed

From: Michael Banck <[email protected]>
To: James Cloos <[email protected]>
Cc: [email protected]
Subject: Re: deb’s pg_upgradecluster(1) vs streaming replication
Date: Mon, 19 Jun 2023 11:01:12 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Hi,

On Sat, Jun 17, 2023 at 07:10:23PM -0400, James Cloos wrote:
> Has anyone recently tried updating a streaming replication cluster using
> debian’s pg_upgradecluster(1) on each node?

Note that the word "cluster" in upgradecluster refers to a single
Postgres instance, a.k.a a cluster of databases. It is not designed to
upgrade streaming replication clusters.

> Did things work well?
> 
> My last attempt (11 to 13, as I recall) had issues and I had to drop and
> re-install the db on the secondaries.
> 
> I'd like to avoid that this time...
> 
> Should I expect things to work easily?

No, you need to either rebuild the secondaries or use the rsync method
to resync them from the documentation. The latter is complicated and
iffy though, and not generally recommended I believe.


Michael

view thread (2+ 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]
  Subject: Re: deb’s pg_upgradecluster(1) vs streaming replication
  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