[RESOLVED] Re: Can't drop subscription

[Axel Rau <Axel.Rau@xxxxxxxxx>]

Am 21.02.2022 um 19:22 schrieb Tom Lane <tgl@xxxxxxxxxxxxx>:

Axel Rau <Axel.Rau@xxxxxxxxx> 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

[1] https://elephanttamer.net/?p=58

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