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: restarting logical replication after upgrading standby
Date: 2022-02-03 16:06:53
Message-ID: a4ddf516-469f-2101-069b-033644230ac0@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Axel Rau 2022-02-03 16:53:26 Re: restarting logical replication after upgrading standby
Previous Message Victor Sudakov 2022-02-03 15:15:44 Re: pgbouncer logs and its efficiency