út 13. 10. 2020 v 18:57 odesílatel Bruce Momjian <br...@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 <br...@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. Regards Pavel > -- > Bruce Momjian <br...@momjian.us> https://momjian.us > EnterpriseDB https://enterprisedb.com > > The usefulness of a cup is in its emptiness, Bruce Lee > >
