Re: lost replication slots after pg_upgrade

2020-10-13 Thread Bruce Momjian
On Tue, Oct 13, 2020 at 11:34:27PM +0200, Peter Eisentraut wrote: > On 2020-10-13 19:23, Pavel Stehule wrote: > > 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

Re: lost replication slots after pg_upgrade

2020-10-13 Thread Peter Eisentraut
On 2020-10-13 19:23, Pavel Stehule wrote: 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 upgrad

Re: lost replication slots after pg_upgrade

2020-10-13 Thread Pavel Stehule
út 13. 10. 2020 v 18:57 odesílatel Bruce Momjian 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 > napsal: > > > > On Tue, Oct 13, 2020 at 06:20:41PM +0200, Pavel Stehule wrote: > > > Hi > > > > >

Re: lost replication slots after pg_upgrade

2020-10-13 Thread Bruce Momjian
On Tue, Oct 13, 2020 at 06:37:14PM +0200, Pavel Stehule wrote: > > > út 13. 10. 2020 v 18:33 odesílatel Bruce Momjian napsal: > > On Tue, Oct 13, 2020 at 06:20:41PM +0200, Pavel Stehule wrote: > > Hi > > > > One customer reports issue related to pg_upgrade. > > > > I fou

Re: lost replication slots after pg_upgrade

2020-10-13 Thread Pavel Stehule
út 13. 10. 2020 v 18:33 odesílatel Bruce Momjian 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

Re: lost replication slots after pg_upgrade

2020-10-13 Thread Bruce Momjian
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 do