Postgres Pro
Downloads
Home   >   mailing lists

Re: restarting logical replication after upgrading standby - Mailing list pgsql-admin

From Axel Rau
Subject Re: restarting logical replication after upgrading standby
Date
Msg-id 43f0b97f-5723-20c5-3a4b-f5d4e643e9c1@Chaos1.DE
Whole thread Raw
In response to restarting logical replication after upgrading standby  (Axel Rau <Axel.Rau@chaos1.de>)
List pgsql-admin
Tree view 
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
Attachment

pgsql-admin by date:

Previous
From: Axel Rau
Date:
Subject: restarting logical replication after upgrading standby
Next
From: "James Pang (chaolpan)"
Date:
Subject: any impact to DML sql statements when checkpoint starting