[RESOLVED] Re: Can't drop subscription

Поиск
Список
Период
Сортировка
От Axel Rau
Тема [RESOLVED] Re: Can't drop subscription
Дата
Msg-id EBE2158F-70B7-4E09-99ED-1F1DFF7D7F4C@Chaos1.DE
обсуждение исходный текст
Ответ на Re: Can't drop subscription  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Axel Rau
Дата:
Сообщение: [RESOLVED] Re: restarting logical replication after upgrading standby
Следующее
От: Marcia Rocha
Дата:
Сообщение: Re: postgresql14-contrib does not install with libpython 3.7