Can't drop subscription

From: Axel Rau <Axel(dot)Rau(at)Chaos1(dot)DE>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Can't drop subscription
Date: 2022-02-21 17:28:01
Message-ID: 68BABAB6-10DC-476A-8A16-39D94F231834@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2022-02-21 17:34:13 Re: Can't drop subscription
Previous Message Ni Ne 2022-02-21 16:35:53 Re: Programmatic access to the SQL tab of pgadmin