password_required.sql

application/sql

Filename: password_required.sql

Type: application/sql

Part: 1

Message: Questions about the new subscription parameter: password_required

--
\c tests_pg16 postgres
--
SELECT version();
--
CREATE SUBSCRIPTION sub_pg16   
       CONNECTION 'host=/var/run/postgresql port=5437 user=user_pub_pg16 dbname=tests_pg16'
       PUBLICATION pub_pg16;
--
ALTER SUBSCRIPTION sub_pg16 OWNER TO sub_owner ;
--
\x
\dRs+
\du+
\l tests_pg16
\x
--
\c - sub_owner 
--
ALTER SUBSCRIPTION sub_pg16 DISABLE;
--
ALTER SUBSCRIPTION sub_pg16 ENABLE;
--
ALTER SUBSCRIPTION sub_pg16 RENAME TO sub_pg16_renamed;
--
DROP SUBSCRIPTION sub_pg16_renamed ;
--
\c - postgres
--
DROP SUBSCRIPTION sub_pg16_renamed;
--
ALTER SUBSCRIPTION sub_pg16_renamed OWNER TO postgres;
--
DROP SUBSCRIPTION sub_pg16_renamed ;