Can't drop subscription

Поиск
Список
Период
Сортировка
От Axel Rau
Тема Can't drop subscription
Дата
Msg-id 68BABAB6-10DC-476A-8A16-39D94F231834@Chaos1.DE
обсуждение исходный текст
Ответы Re: Can't drop subscription  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-admin
While following this receipt:
    https://elephanttamer.net/?p=58
I’ getting:
    ERROR: subscription \"meteo\" does not exist“
with this command:
    psql  -c \"DROP SUBSCRIPTION meteo\“
Same on both subscribers:
- - -
operations=# select oid,subdbid,subname,subowner,subenabled,subslotname,subpublications from
pg_catalog.pg_subscription;
  oid  | subdbid | subname | subowner | subenabled | subslotname | subpublications
-------+---------+---------+----------+------------+-------------+-----------------
 16451 |   16388 | meteo   |       10 | t          | meteo_dbb4  | {meteo}
(1 row)
- - -
operations=# select oid,subdbid,subname,subowner,subenabled,subslotname,subpublications from
pg_catalog.pg_subscription;
  oid  | subdbid | subname | subowner | subenabled | subslotname | subpublications
-------+---------+---------+----------+------------+-------------+-----------------
 16455 |   16388 | meteo   |    16384 | t          | meteo_dbb5  | {meteo}
(1 row)
- - -

How can I drop the subscriptions?

Shouldn’t there be 2 different subscriptions for 2 subscribers to the same publisher?

Any help appreciated,
Axel
---
PGP-Key: CDE74120  ☀  computing @ chaos claudius




В списке pgsql-admin по дате отправления:

Предыдущее
От: Marcia Rocha
Дата:
Сообщение: postgresql14-contrib does not install with libpython 3.7
Следующее
От: Ron
Дата:
Сообщение: Re: Can't drop subscription