From: | Siraj G <tosiraj(dot)g(at)gmail(dot)com> |
---|---|
To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Logical replication data lag |
Date: | 2024-07-31 04:39:48 |
Message-ID: | CAC5iy63ONgYngt9ucVk0BO4mzYjnR0WDCdU_HgPtc+SukdJkfw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Sorry, just wanted to make a little correction:
I get the status report in the target as replicating when I query this:
SELECT * FROM pglogical.show_subscription_status();
But I do not know how to check the stats for this.
Appreciate any help.
On Wed, Jul 31, 2024 at 8:49 AM Siraj G <tosiraj(dot)g(at)gmail(dot)com> wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | SOzcn | 2024-07-31 05:05:15 | Re: DR setup in RHOS |
Previous Message | Siraj G | 2024-07-31 03:19:12 | Logical replication data lag |