Postgres Pro
Downloads
Home   >   mailing lists

Re: Replication lag due to lagging restart_lsn - Mailing list pgsql-performance

From milist ujang
Subject Re: Replication lag due to lagging restart_lsn
Date
Msg-id CACG9ogy3diqEZAydXE=D-h7q1+vFgLbKRpU4HU12R+X-WpmzWg@mail.gmail.com
Whole thread Raw
In response to Re: Replication lag due to lagging restart_lsn  (milist ujang <ujang.milist@gmail.com>)
List pgsql-performance
Tree view
Finally got this useful tool:

Since I usually do scheduled switchover, this tool really helps a lot.

On Tue, Apr 11, 2023 at 10:39 AM milist ujang <ujang.milist@gmail.com> wrote:
I have a case that master has been restarted many times, restart_lsn not moved since nov 2022 till today apr 2023.
I have tried pg_replication_slot_advance() but no luck :-(

postgres 12.8
1 master (4 publisher) many SR slaves, and 1 logical replication (4 subscribers) 

Is there a chance to edit the state file under the pg_replslots folder?
 
--
regards

ujang jaenudin | Self-Employed, DBA Consultant
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab

pgsql-performance by date:

Previous
From: Michael Christofides
Date:
Subject: Re: Is there any tool which will help me run and explain analyze about 150 queries?
Next
From: André Rodrigues
Date:
Subject: Postgres Metrics