Re: Correct query to check streaming replication lag

Поиск
Список
Период
Сортировка
От Sameer Kumar
Тема Re: Correct query to check streaming replication lag
Дата
Msg-id CADp-Sm6ZEhVhKe=u=AJZD1DC=EbJvS5Wnxg=wkPrrZGONwGNaA@mail.gmail.com
обсуждение исходный текст
Ответ на Correct query to check streaming replication lag  (Granthana Biswas <granthana@zedo.com>)
Ответы Re: Correct query to check streaming replication lag
Re: Correct query to check streaming replication lag
Список pgsql-general
Дерево обсуждения


We are already using the following query:

SELECT CASE WHEN pg_last_xlog_receive_location(
) = pg_last_xlog_replay_location() THEN 0 ELSE EXTRACT (EPOCH FROM now() - pg_last_xact_replay_timestamp()) END AS log_delay;

This is (delay) not the correct thing to monitor.

We cannot use pg_xlog_location_diff as we use postgresql 9.1.

You can still use the other two methods I mentioned.


Regards
Sameer
Ashnik Pte Ltd, Singapore

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Correct query to check streaming replication lag
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Correct query to check streaming replication lag