1CREATE OR REPLACE FUNCTION pglogical.create_subscription(subscription_name name, provider_dsn text, 2 replication_sets text[] = '{default,default_insert_only,ddl_sql}', synchronize_structure boolean = true, 3 synchronize_data boolean = true, forward_origins text[] = '{all}') 4RETURNS oid STRICT VOLATILE LANGUAGE c AS 'MODULE_PATHNAME', 'pglogical_create_subscription'; 5 6DO $$ 7BEGIN 8 IF (SELECT count(1) FROM pglogical.node) > 0 THEN 9 SELECT * FROM pglogical.create_replication_set('ddl_sql', true, false, false, false); 10 END IF; 11END; $$; 12 13UPDATE pglogical.subscription SET sub_replication_sets = array_append(sub_replication_sets, 'ddl_sql'); 14 15WITH applys AS ( 16 SELECT sub_name FROM pglogical.subscription WHERE sub_enabled 17), 18disable AS ( 19 SELECT pglogical.alter_subscription_disable(sub_name, true) FROM applys 20) 21SELECT pglogical.alter_subscription_enable(sub_name, true) FROM applys; 22