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-03 16:53:26
Message-ID: 43f0b97f-5723-20c5-3a4b-f5d4e643e9c1@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

The upgrade was from 12.9 to 13.5 .

Am 03.02.22 um 17:06 schrieb Axel Rau:
> Hi all,
>
> I'm writing an ansible role to upgrade instances.
>
> I did a shutdown of the the standby and run pg_upgrade to completeion.
> Stanby is running and configured as before, but receives no replication
> data.
>
> Replication to another standby is working, but the slot of the upgraded
> standby is inactive.
> What is the recommended procedure to get the upgraded standby in sync?
>
> Axel

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message James Pang (chaolpan) 2022-02-04 00:28:43 any impact to DML sql statements when checkpoint starting
Previous Message Axel Rau 2022-02-03 16:06:53 restarting logical replication after upgrading standby