public inbox for [email protected]  

help / color / mirror / Atom feed
From: Bruce Momjian <[email protected]>
To: Nikhil Shetty <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Adding more detail to pg_upgrade documentation
Date: Tue, 30 Aug 2022 22:08:51 -0400
Message-ID: <Yw7Cs7gJFr5w0/[email protected]> (raw)
In-Reply-To: <CAFpL5Vx7Z676aa+Gyg6igONDDg+Pmoy=vyZ1Vc0YiZKc-Cyp1A@mail.gmail.com>
References: <CAFpL5Vx7Z676aa+Gyg6igONDDg+Pmoy=vyZ1Vc0YiZKc-Cyp1A@mail.gmail.com>

On Sat, May 28, 2022 at 12:11:31AM +0530, Nikhil Shetty wrote:
> Hi,
> 
> We are upgrading from Postgres 11 to 13. During upgrade we found that the
> physical slots on the old cluster are not copied to the new cluster.
> 
> This information is not mentioned in the documentation - https://
> www.postgresql.org/docs/13/pgupgrade.html
> 
> Just thought it would be good to have this detail

All releases after 2022-07-14 have this mentioned:

	commit 47ae6948f0
	Author: Bruce Momjian <[email protected]>
	Date:   Thu Jul 14 16:34:30 2022 -0400
	
	    pg_upgrade doc: mention that replication slots must be recreated
	
	    Reported-by: Nikhil Shetty
	
	    Discussion: https://postgr.es/m/CAFpL5Vxastip0Jei-K-=7cKXTg=5sahSe5g=om=x68NOX8+PUA@mail.gmail.com
	
	    Backpatch-through: 10

So, these releases:

	https://www.postgresql.org/about/news/postgresql-145-138-1212-1117-1022-and-15-beta-3-released-2496/
	PostgreSQL 14.5, 13.8, 12.12, 11.17, 10.22

See here:

	https://www.postgresql.org/docs/15/pgupgrade.html
	Section 11.7
-->	Replication slots are not copied and must be recreated.

-- 
  Bruce Momjian  <[email protected]>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson







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: Adding more detail to pg_upgrade documentation
  In-Reply-To: <Yw7Cs7gJFr5w0/[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