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 <bruce@xxxxxxxxxx> 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@xxxxxxxxxxxxxx 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 <bruce@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson
