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.mil...@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
