Question about monitoring PostgreSQL 10 streaming replication health

From: Bilal Abdulkadir Muhammed <bilalabdulkadir286(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Question about monitoring PostgreSQL 10 streaming replication health
Date: 2026-07-20 14:23:07
Message-ID: CAJ1M1K2cvOYx=5G5-bbnAQcLYFNi8ngsx55ORs82mPASJwYRQQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

*Hello PostgreSQL community,*

I am monitoring a PostgreSQL 10 standby server using:

pg_last_xlog_receive_location()
and
pg_last_xlog_replay_location()

The current query only checks replay lag. I would like guidance on a more
comprehensive monitoring approach that can detect:

1. Standby disconnected from the primary.
2. WAL receiver process stopped.
3. Required WAL segment removed from the primary
(for example: "requested WAL segment has already been removed").

I would like to know:
- Which SQL checks are recommended for these scenarios?
- Which conditions require external monitoring or log analysis?
- What is the recommended practice for monitoring PostgreSQL 10 streaming
replication health?

Thank you.

Bilal Abdulkadir Muhammed
bilalabdulkadir286(at)gmail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2026-07-21 09:08:00 Re: Question about monitoring PostgreSQL 10 streaming replication health
Previous Message Merlin Moncure 2026-07-17 17:15:39 Re: Transaction Isolation level for ERP software