MIME-Version: 1.0
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 9 Jan 2026 10:50:28 -0500
Message-ID: 
 <CANzqJaBG-MkG9YTt8pYTnHu+9U5wpwEcWQKzx2aOu85C6Uzn-w@mail.gmail.com>
Subject: Better way to monitor for failed replication?
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b13f550647f67cbc"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaBG-MkG9YTt8pYTnHu%2B9U5wpwEcWQKzx2aOu85C6Uzn-w%40mail.gmail.com>
Precedence: bulk

--000000000000b13f550647f67cbc
Content-Type: text/plain; charset="UTF-8"

Currently, in a bash script, I run this SELECT statement against the
Primary server which is supposed to replicate to multiple servers.  If
active == f, I send an alter email.

postgres=# SELECT rs.slot_name, rs.active, sr.client_hostname
from pg_replication_slots rs
    left outer join pg_stat_replication sr on rs.active_pid = sr.pid;
  slot_name   | active | client_hostname
--------------+--------+-----------------
 pgstandby1   | t      | BBOPITCPGS302B
 replicate_dr | f      |
(2 rows)

Is there a better way to check for replication that's supposed to be
happening, but isn't (like PG on the replica was stopped for some reason)?

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000b13f550647f67cbc
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Currently, in a bash script, I run this SELECT statem=
ent against the Primary server which is supposed to=C2=A0replicate=C2=A0to =
multiple servers.=C2=A0 If active =3D=3D f, I send an alter email.</div><di=
v><br></div><div><font face=3D"monospace">postgres=3D# SELECT rs.slot_name,=
 rs.active, sr.client_hostname</font></div><div><font face=3D"monospace">fr=
om pg_replication_slots rs <br>=C2=A0 =C2=A0 left outer join pg_stat_replic=
ation sr on rs.active_pid =3D sr.pid;<br>=C2=A0 slot_name =C2=A0 | active |=
 client_hostname <br>--------------+--------+-----------------<br>=C2=A0pgs=
tandby1 =C2=A0 | t =C2=A0 =C2=A0 =C2=A0| BBOPITCPGS302B<br>=C2=A0replicate_=
dr | f =C2=A0 =C2=A0 =C2=A0| <br>(2 rows)</font></div><div><br></div><div>I=
s there a better way to check=C2=A0for replication that&#39;s supposed to b=
e happening, but isn&#39;t (like PG on the replica was stopped for some rea=
son)?</div><div><br></div><span class=3D"gmail_signature_prefix">-- </span>=
<br><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_sign=
ature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Do=
n&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster=
!</div></div></div></div></div></div>

--000000000000b13f550647f67cbc--