Re: Replication lag from transaction logs

Поиск
Список
Период
Сортировка
От Fabio Pardi
Тема Re: Replication lag from transaction logs
Дата
Msg-id 975db215-0ba1-0a36-178d-dd4078fc0d50@portavita.eu
обсуждение исходный текст
Ответ на Replication lag from transaction logs  (Debraj Manna <subharaj.manna@gmail.com>)
Ответы Re: Replication lag from transaction logs  (Keith <keith@keithf4.com>)
Список pgsql-admin

That I know, if standby is down, you cannot know exactly the last applied transaction log file.

But you could get a gross estimate if you check how many WAL files is the standby behind, just listing the WAL files on the master and on the standby.

Given that you can login on the standby machine.

regards,

fabio pardi


On 18/06/18 14:43, Debraj Manna wrote:
Is it possible to figure out the replication lag from transaction log files in the slave and master without querying postgres on the slave? Basically figuring out the replication lag in a slave when the postgres is down in that slave.

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

Предыдущее
От: Debraj Manna
Дата:
Сообщение: Replication lag from transaction logs
Следующее
От: Keith
Дата:
Сообщение: Re: Replication lag from transaction logs