Skip to content

Instantly share code, notes, and snippets.

@savelevvo

savelevvo/restart_subscriptions.sql

Created July 24, 2019 09:38
Show Gist options
  • Save savelevvo/71050d8679fc9c8be9b411807264eebf to your computer and use it in GitHub Desktop.
Save savelevvo/71050d8679fc9c8be9b411807264eebf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
restart_subscriptions.sql
ALTER SUBSCRIPTION my_table_sub DISABLE;
ALTER SUBSCRIPTION my_table_sub SET (slot_name = NONE);
DROP SUBSCRIPTION my_table_sub;
DELETE FROM my_table;
CREATE SUBSCRIPTION my_table_sub CONNECTION 'dbname=xxx user=xxx password=xxx host=xxx port=xxx' PUBLICATION my_table_pub;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment