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
