From: | Damir Markovic <damir(at)damirda(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Monitoring warm standby |
Date: | 2019-03-14 12:02:38 |
Message-ID: | CAMLLpyibzuS_CLv_m3ZxStE+fsnYYVannBh2mrHNXhC085pcGA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Angélica Barcellos | 2019-03-14 12:05:18 | Retirar e-mail da lista |
Previous Message | Michael Cassaniti | 2019-03-14 07:57:52 | Re: Notification or action when WAL archives fully restored and streaming replication started |