pglogical: list replication sets?

Question

I looked at the docs of pglogical.

But I could not find a way to list all replication sets, which I created with create_replication_set().

How to list all replication sets?

score 6 · Accepted Answer · answered Sep 23 '19 at 20:47

6

According to the source, that should be as simple as

SELECT * FROM pglogical.replication_set;

You need to be a superuser to select from that table.

answered Sep 23 '19 at 20:47

Laurenz Albe

Yes, it will list the set_id, set_nodeid, set_name, replicate_insert, replicate_update, replicate_delete and replicate_truncate for the ```replication_set``` – Sreeram Nair Sep 30 '19 at 01:07

1 Answers1