| 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: | Whole Thread | Raw Message | 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
| 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 |