Re: Logical replication data lag
| От | Siraj G |
|---|---|
| Тема | Re: Logical replication data lag |
| Дата | |
| Msg-id | CAC5iy63ONgYngt9ucVk0BO4mzYjnR0WDCdU_HgPtc+SukdJkfw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Logical replication data lag (Siraj G <tosiraj.g@gmail.com>) |
| Ответы |
Re: Logical replication data lag
|
| Список | 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.g@gmail.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!RegardsSiraj
В списке pgsql-admin по дате отправления: