Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.120.0.1.13\))
Subject: Re: Lost replication slots after pg_upgrade.
From: John DeSoi <desoi@pgedit.com>
In-Reply-To: <20220208080843.an4ljxpjwncz5wqi@jrouhaud>
Date: Tue, 8 Feb 2022 15:11:49 -0600
Cc: Nikhil Shetty <nikhil.dba04@gmail.com>,
 Victor Sudakov <vas@sibptus.ru>,
 Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <3CC0BC49-3376-4CDA-A133-C0A142BC6A88@pgedit.com>
References: 
 <CAFpL5Vws1tJnO8_CeOBO6e2q5K4Zbe4==redhV1yLSekm1U4TQ@mail.gmail.com>
 <Yftm6IwtRKg5QB7P@admin.sibptus.ru>
 <CAFpL5Vx__E4hfvvoCQOmGEtAygowJzto_=sQHUTNbXOpUo1PUQ@mail.gmail.com>
 <YgHkxM8Ocn4F3zWi@admin.sibptus.ru>
 <CAFpL5VxJiFdZ=UKAGNEqNo=U3eSDSFx1uabrrst-GJu2z3zqUg@mail.gmail.com>
 <20220208070404.d2dizlt6nvz2g3og@jrouhaud>
 <CAFpL5Vw5O3mzhjS6NuNZSCUH8Jr+=KXVPPZ-+y5--20W6cSFmA@mail.gmail.com>
 <20220208080843.an4ljxpjwncz5wqi@jrouhaud>
To: Julien Rouhaud <rjuju123@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/3CC0BC49-3376-4CDA-A133-C0A142BC6A88%40pgedit.com>
Precedence: bulk


> On Feb 8, 2022, at 2:08 AM, Julien Rouhaud <rjuju123@gmail.com> wrote:
>=20
> Because pg_upgrade modifies your primary instance in such a way that a =
standby
> can't simply keep replicating from it.

Would it work as expected if before pg_upgrade on the standby:

alter subscription my_subscription disable;
alter subscription my_subscription set (slot_name =3D NONE);

And then after pg_upgrade:

alter subscription my_subscription enable;

I have not tried it yet, but I thought this would be the simplest =
option.

John DeSoi, Ph.D.