Обсуждение: Adding more detail to pg_upgrade documentation
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
Thanks and Regards,
Nikhil
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@momjian.us> 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 <bruce@momjian.us> https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson