SELECT subscription_name, status FROM pglogical.show_subscription_status();
where status is current
where status isupdated: this actually doesn't work for current(current versions of?) pglogical either. i read about it in a blog post but I don't think it's the actual behavior. see:
- this comment https://github.com/2ndQuadrant/pglogical/issues/208#issuecomment-573636728
- my question to pglogical here: https://github.com/2ndQuadrant/pglogical/issues/252