Re: Replication lag due to lagging restart_lsn

Поиск
Список
Период
Сортировка
От milist ujang
Тема Re: Replication lag due to lagging restart_lsn
Дата
Msg-id CACG9ogy3diqEZAydXE=D-h7q1+vFgLbKRpU4HU12R+X-WpmzWg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replication lag due to lagging restart_lsn  (milist ujang <ujang.milist@gmail.com>)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Michael Christofides
Дата:
Сообщение: Re: Is there any tool which will help me run and explain analyze about 150 queries?
Следующее
От: André Rodrigues
Дата:
Сообщение: Postgres Metrics