How to list pglogical nodes?

2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.

http://2ndquadrant.com/en/resources/pglogical/

Other

987 stars 153 forks source link

How to list pglogical nodes? #459

Closed ApproximateIdentity closed 7 months ago

ApproximateIdentity commented 7 months ago

I have been looking through all the docs and I see how I can create nodes and drop nodes, but I don't see how I can list previously created nodes. Are there set tables where this kind of data is stored (or some other api built into pglogical)? Ideally I'd be able to track all the various pglogical operations in similar ways.

Apologies in advance if it's in the docs, but I just can't seem to find this information.

ApproximateIdentity commented 7 months ago

Okay immediately after asking, I just realized that there are tables pglogical.* with a lot of info and that my question is almost certainly answered in one of those. (Not sure how I missed that.) Sorry for the noise!