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-05 20:50:01
Message-ID: 757323a0-6eeb-3ec1-d578-d98214247c41@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Am 03.02.22 um 17:06 schrieb Axel Rau:
> Replication to another standby is working, but the slot of the upgraded
> standby is inactive.
Also the subscription has subenabled set to false.
Enabling it, turns on the active bit at the publisher side, but does not
start replication.
Recreating the subscription does not help either.

There should be a solution as logical replication is documented to
support upgrade of the standby.

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vijaykumar Jain 2022-02-05 22:41:57 Re: restarting logical replication after upgrading standby
Previous Message Ibrahim Shaame 2022-02-05 12:06:47 Re: Problem starting two postgresql clusters on the same host