Make sure we create the users both on provider and subscriber in tests

PJMODOS · PJMODOS · commit b26d1a14f44c · 2016-01-15T20:52:17.000+01:00
diff --git a/expected/init.out b/expected/init.out
@@ -2,6 +2,13 @@
 -- but it's blocked by bug 37906
 SELECT * FROM pglogical_regress_variables()
 \gset
+\c :provider_dsn
+SET client_min_messages = 'warning';
+DROP USER IF EXISTS nonsuper;
+DROP USER IF EXISTS super;
+CREATE USER nonsuper WITH replication;
+CREATE USER super SUPERUSER;
+\c :subscriber_dsn
 SET client_min_messages = 'warning';
 DROP USER IF EXISTS nonsuper;
 DROP USER IF EXISTS super;
diff --git a/sql/init.sql b/sql/init.sql
@@ -3,6 +3,15 @@
 SELECT * FROM pglogical_regress_variables()
 \gset
 
+\c :provider_dsn
+SET client_min_messages = 'warning';
+DROP USER IF EXISTS nonsuper;
+DROP USER IF EXISTS super;
+
+CREATE USER nonsuper WITH replication;
+CREATE USER super SUPERUSER;
+
+\c :subscriber_dsn
 SET client_min_messages = 'warning';
 DROP USER IF EXISTS nonsuper;
 DROP USER IF EXISTS super;
