Hello Admins!
I am trying to find the replication lag in the target that is being
replicated using pglogical. I do not see any data in pg_stat_subscription.
We are replicating data from GCP cloud SQL to a compute instance within the
same VCN.
I get the status report in the target as replication, but not sure why
pg_stat_subscription does not show anything.
Should I do it programmatically by creating a heartbeat table on the
source, add it to the replication and monitor the data in this to get the
report?
Thanks in advance!
Regards
Siraj