On 2/21/22 11:28 AM, Axel Rau wrote:
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\“
Why the backslashes, instead of:
psql -c "DROP SUBSCRIPTION meteo;“
(Presumably you're defining the host and database in PG* environment variables?)
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
--
Angular momentum makes the world go 'round.
