Re: Reading WALs

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: PegoraroF10 <marcos(at)f10(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org
Subject: Re: Reading WALs
Date: 2020-03-14 15:15:08
Message-ID: 4440833e-e4e4-53ec-b0f5-06a44dd2bd31@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/14/20 6:48 AM, PegoraroF10 wrote:
> On my built in logical replication I see that sometimes it tooks a long time
> to be updated with master. The question is how can I see what is being done
> on replica ? I know I can have a WAL reader, I tried WAL2JSON, it listen all
> data which comes from master, but as I understood when I use that plugin
> that data is discarded, so, not replicated.
>
> Is that correct ? Can I see what is coming to replica server and apply that
> change to server as usual ?

See what is happening:

https://www.postgresql.org/docs/12/monitoring-stats.html#PG-STAT-SUBSCRIPTION

>
>
>
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PegoraroF10 2020-03-14 17:11:11 Re: Reading WALs
Previous Message PegoraroF10 2020-03-14 13:48:55 Reading WALs