[RESOLVED] Re: Can't drop subscription - Mailing list pgsql-admin

From Axel Rau
Subject [RESOLVED] Re: Can't drop subscription
Date
Msg-id EBE2158F-70B7-4E09-99ED-1F1DFF7D7F4C@Chaos1.DE
Whole thread Raw
In response to Re: Can't drop subscription  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin


Am 21.02.2022 um 19:22 schrieb Tom Lane <tgl@sss.pgh.pa.us>:

Axel Rau <Axel.Rau@Chaos1.DE> writes:
This was the  error message from an ansible script. I assumed, ansible did the quoting.
Doing it per hand, works:

Seems likely that the ansible script is connecting to a different
database.  Log-rep subscriptions are database-local objects, not
cluster-wide, so it matters.

The problem did not happen again after I did a clean clone, where I let CREATE SUBSCRIPTION create the slot.
I implemented this recipe [1] in ansible and it upgraded 2 subscribers and one publisher in 4 minutes from 12 to 13. (-;

Thanks for all your help,
Axel

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

pgsql-admin by date:

Previous
From: Axel Rau
Date:
Subject: [RESOLVED] Re: restarting logical replication after upgrading standby
Next
From: Marcia Rocha
Date:
Subject: Re: postgresql14-contrib does not install with libpython 3.7