| From: | milist ujang <ujang(dot)milist(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Replication lag due to lagging restart_lsn |
| Date: | 2023-04-15 10:41:16 |
| Message-ID: | CACG9ogy3diqEZAydXE=D-h7q1+vFgLbKRpU4HU12R+X-WpmzWg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Finally got this useful tool:
https://github.com/EnterpriseDB/pg_failover_slots
Since I usually do scheduled switchover, this tool really helps a lot.
On Tue, Apr 11, 2023 at 10:39 AM milist ujang <ujang(dot)milist(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | André Rodrigues | 2023-04-15 11:04:12 | Postgres Metrics |
| Previous Message | Michael Christofides | 2023-04-12 09:17:30 | Re: Is there any tool which will help me run and explain analyze about 150 queries? |