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