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
