1SELECT * FROM pglogical_regress_variables() 2\gset 3 4\c :provider_dsn 5SELECT * FROM pglogical.drop_node(node_name := 'test_provider'); 6 7SELECT plugin, slot_type, active FROM pg_replication_slots; 8SELECT count(*) FROM pg_stat_replication; 9 10\c :subscriber_dsn 11SELECT * FROM pglogical.drop_subscription('test_subscription'); 12SELECT * FROM pglogical.drop_node(node_name := 'test_subscriber'); 13 14\c :provider_dsn 15SELECT * FROM pglogical.drop_node(node_name := 'test_provider'); 16 17\c :subscriber_dsn 18DROP OWNED BY nonsuper, super CASCADE; 19 20\c :provider_dsn 21DROP OWNED BY nonsuper, super CASCADE; 22 23\c :provider1_dsn 24DROP OWNED BY nonsuper, super CASCADE; 25 26\c :orig_provider_dsn 27DROP OWNED BY nonsuper, super CASCADE; 28 29\c :subscriber_dsn 30SET client_min_messages = 'warning'; 31DROP ROLE IF EXISTS nonsuper, super; 32 33\c :provider_dsn 34SET client_min_messages = 'warning'; 35DROP ROLE IF EXISTS nonsuper, super; 36 37\c :provider1_dsn 38SET client_min_messages = 'warning'; 39DROP ROLE IF EXISTS nonsuper, super; 40 41\c :orig_provider_dsn 42SET client_min_messages = 'warning'; 43DROP ROLE IF EXISTS nonsuper, super; 44