Re: Reading WALs

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.klaver@aklaver.com