跟随https://stackoverflow.com/questions/68720250/cannot-drop-subscription-from-postgresql
看来要取消订阅,您首先需要连接到关联的数据库。但是我不确定如何确定订阅属于哪个数据库?
我想删除的订阅示例:
finder_v2=# SELECT * FROM pg_subscription;
subdbid | subname | subowner | subenabled | subconninfo | subslotname | subsynccommit | subpublications
---------+---------+----------+------------+---------------------------------------------------------------------------------------------------+-------------+---------------+-----------------
16384 | chris | 10 | t | host=localhost user=postgres password=mysecretpassword port=5555 dbname=finder connect_timeout=10 | chris | off | {chris}
(1 row)
我对此进行了网络搜索,并阅读了一些 postgres 文档,但仍然无法弄清楚。
subdbid
标识定义订阅的数据库:或将其加入 pg_subscription: