Monitoring warm standby

Поиск
Список
Период
Сортировка
От Damir Markovic
Тема Monitoring warm standby
Дата
Msg-id CAMLLpyibzuS_CLv_m3ZxStE+fsnYYVannBh2mrHNXhC085pcGA@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
I have multiple warm standby replicas of PostgreSQL 11, used by analytics.
Some of the databases are not very active and I have a problem to figure out if the recovery is in progress or actually there is nothing to recover (because of master inactivity).

I set target time on replica like this:
recovery_target_time = '2019-03-13 12:00:00 UTC'

I check pg_is_wal_replay_paused() - false. Ok, replica is still catching up.

select max(modification) from pg_ls_waldir(); - '2019-03-13 10:25:15'. Ok, I didn't receive any WAL files in a while.

select pg_last_xact_replay_timestamp(); - '2019-03-13 10:15:42.289668'. Last transaction is even older.

The question now is how can I know if that last WAL file downloaded is fully processed or maybe there is a long running transaction that is still being in progress?

Thank you very much,
Damir

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

Предыдущее
От: Michael Cassaniti
Дата:
Сообщение: Re: Notification or action when WAL archives fully restored andstreaming replication started
Следующее
От: Angélica Barcellos
Дата:
Сообщение: Retirar e-mail da lista