password_required2.sql

application/sql

Filename: password_required2.sql

Type: application/sql

Part: 3

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 CONNECTION 'host=/var/run/postgresql port=5437 user=user_pub_pg16 dbname=tests_pg16 application_name=preq';
--
\c - postgres
--
ALTER SUBSCRIPTION sub_pg16 SET (password_required = false) ;
--
\c - sub_owner 
--
ALTER SUBSCRIPTION sub_pg16 CONNECTION 'host=/var/run/postgresql port=5437 user=user_pub_pg16 dbname=tests_pg16 application_name=preq';
--
ALTER SUBSCRIPTION sub_pg16 DISABLE;
--
ALTER SUBSCRIPTION sub_pg16 ENABLE;
--
DROP SUBSCRIPTION sub_pg16;