Postgres Pro
Downloads
Home   >   mailing lists

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

From Axel Rau
Subject [RESOLVED] Re: restarting logical replication after upgrading standby
Date
Msg-id C6E4EC3E-7959-40C7-AB65-880348C93B9D@Chaos1.DE
Whole thread Raw
In response to Re: restarting logical replication after upgrading standby  (Axel Rau <Axel.Rau@chaos1.de>)
List pgsql-admin
Tree view


Am 08.02.2022 um 18:25 schrieb Axel Rau <Axel.Rau@chaos1.de>:


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

I implemented this recipe in ansible and it upgraded 2 subscribers and one publisher in 4 minutes. (-;

Thanks for all your help,
Axel
---
PGP-Key: CDE74120  ☀  computing @ chaos claudius

Attachment

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: Pg_dump backup
Next
From: Axel Rau
Date:
Subject: [RESOLVED] Re: Can't drop subscription