N
Neon2mo ago
afraid-scarlet

Cannot drop subscription

I created a subscription to a publication I have on another database, but I forgot to pass the option to copy the data. I figured it would be easy enough to drop the subscription and recreate it with that option, but I cannot get neon to drop the subscription no matter what I try. I've been led to disable the subscription and set the slot to none and I see the subscription when I select, but I can't drop it for some reason. This is the error I get when trying to drop the subscription with DROP SUBSCRIPTION sub_name;
ERROR: could not drop replication slot "pg_147456_sync_107276_7448440708624468072" on publisher: ERROR: syntax error at or near "DROP_REPLICATION_SLOT" LINE 1: DROP_REPLICATION_SLOT pg_147456_sync_107276_7448440708624468... ^ (SQLSTATE 08006)
ERROR: could not drop replication slot "pg_147456_sync_107276_7448440708624468072" on publisher: ERROR: syntax error at or near "DROP_REPLICATION_SLOT" LINE 1: DROP_REPLICATION_SLOT pg_147456_sync_107276_7448440708624468... ^ (SQLSTATE 08006)
1 Reply
dependent-tan
dependent-tan2mo ago
Hey! Sorry you're running into issues. Are you currently on a paid plan? In this case, I'd recommend you create a support ticket so we can take a look at your project and see what's happening: neon.com/support - [?] icon in top right corner of the Neon console.

Did you find this page helpful?