Re: restarting logical replication after upgrading standby

From: Axel Rau <Axel(dot)Rau(at)chaos1(dot)de>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: restarting logical replication after upgrading standby
Date: 2022-02-08 17:25:36
Message-ID: 9d4e1962-2638-3cb3-0545-e3cad753f739@Chaos1.DE
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Am 08.02.22 um 17:32 schrieb Axel Rau:
> Am 07.02.22 um 18:00 schrieb Axel Rau:
>> Anybody out there, succeeding with upgrading a logical replication
>> subscriber without resyncing it?
>>
> Here [1] I read, it's unsupported.
> To upgrade a subscriber, you just do a fresh installation of the
> subscriber.

And here [1], I read a howto with pg_upgrade on both publisher and
subscriber with minimum doentime. I will try this and report back.

Axel
[1] https://elephanttamer.net/?p=58

--
PGP-Key: CDE74120 ☀ computing @ chaos claudius

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John DeSoi 2022-02-08 21:11:49 Re: Lost replication slots after pg_upgrade.
Previous Message Dan Smith 2022-02-08 17:08:03 Re: pgadmin doesn't show the tables in brand new created db