út 13. 10. 2020 v 18:57 odesílatel Bruce Momjian <bruce@momjian.us> napsal:
On Tue, Oct 13, 2020 at 06:37:14PM +0200, Pavel Stehule wrote: > > > út 13. 10. 2020 v 18:33 odesílatel Bruce Momjian <bruce@momjian.us> napsal: > > On Tue, Oct 13, 2020 at 06:20:41PM +0200, Pavel Stehule wrote: > > Hi > > > > One customer reports issue related to pg_upgrade. > > > > I found a thread https://www.postgresql-archive.org/ > > > Upgrade-and-re-synchronization-with-logical-replication-pglogical-and-PG-10-td6001990.html > > > > But I didn't find documentation of this limitation? > > So, what is the question? Peter Eisentraut is right that WAL is not > preserved, so replication slots are not preserved. We do have > pg_upgrade instructions for upgrading binary replication, but I assume > people recreate the slots. > > > I cannot find related documentation.
You mean related documentation of how to manage changing replication slots?
no, I just missi note, so after upgrade by pg_upgrade I have to recreate replication slots. Some like
after pg_upgrade you should to do:
a) run analyze .... (it is a known case)
b) recreate replication slots - these slots are not removed in the upgrade process.