Can't drop subscription

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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







[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux