在测试不同场景时,我按照建议运行:
alter subscription mysub set (slot_name = NONE);
drop subscription mysub;
我现在遇到了一个错误:
postgres=# select pg_drop_replication_slot('mysub');
ERROR: replication slot "mysub" does not exist
postgres=# create subscription mysub connection 'host=192.168.1.140 port=5432 user=postgres dbname=postgres' publication mypub, insert_only;
ERROR: could not create replication slot "mysub": ERROR: replication slot "mysub" already exists
postgres=# drop subscription mysub;
ERROR: subscription "mysub" does not exist
我该如何解决这个问题?