[RESOLVED] 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: [RESOLVED] Re: restarting logical replication after upgrading standby
Date: 2022-02-23 20:46:43
Message-ID: C6E4EC3E-7959-40C7-AB65-880348C93B9D@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Am 08.02.2022 um 18:25 schrieb Axel Rau <Axel(dot)Rau(at)chaos1(dot)de <mailto:Axel(dot)Rau(at)chaos1(dot)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 <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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Axel Rau 2022-02-23 20:47:02 [RESOLVED] Re: Can't drop subscription
Previous Message Holger Jakobs 2022-02-23 15:00:27 Re: Pg_dump backup