How to check stream replication latest history status

Поиск
Список
Период
Сортировка
От 徐志宇徐
Тема How to check stream replication latest history status
Дата
Msg-id CAOCebi+JrSwiqABRvmED3AnvLVHtQPF5uvrdmoQ_Nq698yoMVg@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to check stream replication latest history status  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-general
    Hi All
   
      I set up Postgres 11 stream replication env.Use keepalived to control VIP and a script to check Postgres status.
      Usually. I could check the stream replication status by this view "pg_stat_replcation" on primary server.
      Check this view "pg_stat_wal_receiver" on standby server.
     
      Sometime the primary server abnormal or the network interrupt by unexpected issue.
     
      Both of them no record "pg_stat_replcation", "pg_stat_wal_receiver" on that time.
     
      I want to know the stream replication gap between primary and standby before standby promote.
      If the primary and standby have long replay_lag. I don't want to standby server promote.
     
      Is there any view or function which store the latest stream replication gap(replay_lag) between primary and standby ?
      Or it there any workaround to know this stream replication gap(replay_lag) infomation ?  Thanks for your help.

                                                                                  Jack.Xu

В списке pgsql-general по дате отправления:

Предыдущее
От: Alexis Zapata
Дата:
Сообщение: RE: Table : Bloat grow high
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Upgrading to v12