Re: Streaming Recovery - Automated Monitoring

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема Re: Streaming Recovery - Automated Monitoring
Дата
Msg-id AANLkTikAGiPX4WR7im7umxv2-k4Jb5idpPLZ506ZmoqM@mail.gmail.com
обсуждение исходный текст
Ответ на Streaming Recovery - Automated Monitoring  (Karl Denninger <karl@denninger.net>)
Ответы Re: Streaming Recovery - Automated Monitoring  (Karl Denninger <karl@denninger.net>)
Список pgsql-general

I hope u checked point #11  http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_Use
  • 11. You can calculate the replication lag by comparing the current WAL write location on the primary with the last WAL location received/replayed by the standby. They can be retrieved using pg_current_xlog_location on the primary and the pg_last_xlog_receive_location/pg_last_xlog_replay_location on the standby, respectively.
$ psql -c "SELECT pg_current_xlog_location()" -h192.168.0.10 (primary host)pg_current_xlog_location 
--------------------------0/2000000
(1 row)

$ psql -c "select pg_last_xlog_receive_location()" -h192.168.0.20 (standby host)pg_last_xlog_receive_location 
-------------------------------0/2000000
(1 row)

$ psql -c "select pg_last_xlog_replay_location()" -h192.168.0.20 (standby host)pg_last_xlog_replay_location 
------------------------------0/2000000
(1 row)

Regds
Rajesh Kumar Mallah.

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

Предыдущее
От: Karl Denninger
Дата:
Сообщение: Streaming Recovery - Automated Monitoring
Следующее
От: Karl Denninger
Дата:
Сообщение: Re: Streaming Recovery - Automated Monitoring