@@ -83,18 +83,18 @@ SELECT sync_kind, sync_subid, sync_nspname, sync_relname, sync_status FROM pglog
83
83
f | 3848008564 | | | r
84
84
(1 row)
85
85
86
- SELECT * FROM pglogical.show_subscription_status();
87
- subscription_name | status | provider_node | provider_dsn | slot_name | replication_sets | forward_origins
88
- -------------------+-------------+---------------+------------------------------+--------------------------------------------+------------------------------ ---------+-----------------
89
- test_subscription | replicating | test_provider | dbname=regression user=super | pgl_postgres_test_provider_test_sube55bf37 | {default,default_insert_only,ddl_sql} |
86
+ SELECT subscription_name, status, provider_node, replication_sets, forward_origins FROM pglogical.show_subscription_status();
87
+ subscription_name | status | provider_node | replication_sets | forward_origins
88
+ -------------------+-------------+---------------+---------------------------------------+-----------------
89
+ test_subscription | replicating | test_provider | {default,default_insert_only,ddl_sql} |
90
90
(1 row)
91
91
92
92
-- Make sure we see the slot and active connection
93
93
\c :provider_dsn
94
- SELECT plugin, slot_type, database, active FROM pg_replication_slots;
95
- plugin | slot_type | database | active
96
- ------------------+-----------+------------+--------
97
- pglogical_output | logical | regression | t
94
+ SELECT plugin, slot_type, active FROM pg_replication_slots;
95
+ plugin | slot_type | active
96
+ ------------------+-----------+--------
97
+ pglogical_output | logical | t
98
98
(1 row)
99
99
100
100
SELECT count(*) FROM pg_stat_replication;
0 commit comments