Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.120.0.1.13\))
Subject: Re: restarting logical replication after upgrading standby
From: John DeSoi <desoi@pgedit.com>
In-Reply-To: <c534c888-93dd-48e0-fb31-4798bc1ac6c0@Chaos1.DE>
Date: Wed, 9 Feb 2022 07:57:03 -0600
Cc: pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <60559CE6-D89F-4897-883D-1D716A4F654A@pgedit.com>
References: <a4ddf516-469f-2101-069b-033644230ac0@Chaos1.DE>
 <757323a0-6eeb-3ec1-d578-d98214247c41@Chaos1.DE>
 <CAM+6J94Wtzm3M1BwRYjzRzzr9VPkJ+KPtz3M=gWisgP2ywTMZQ@mail.gmail.com>
 <1cc52b6e-484e-8502-65dd-d3ba66982fb5@Chaos1.DE>
 <CAM+6J96j4qErattg-DiqRKFE80GFTn6ag7-Q2A7DKQX1UWUOGQ@mail.gmail.com>
 <c534c888-93dd-48e0-fb31-4798bc1ac6c0@Chaos1.DE>
To: Axel Rau <Axel.Rau@chaos1.de>
Archived-At: 
 <https://www.postgresql.org/message-id/60559CE6-D89F-4897-883D-1D716A4F654A%40pgedit.com>
Precedence: bulk


> On Feb 7, 2022, at 11:00 AM, Axel Rau <Axel.Rau@chaos1.de> wrote:
>=20
> Anybody out there, succeeding with upgrading a logical replication =
subscriber without resyncing it?


I have not tried it, but thought this the idea below would work for =
upgrading the publisher or subscriber with pg_upgrade. Plan to test it =
in a few weeks. If anyone knows it will not work, that will save me some =
time :).


Before pg_upgrade on the subscriber:

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

And then after pg_upgrade:

alter subscription my_subscription enable;

John DeSoi, Ph.D.