MIME-Version: 1.0
From: =?UTF-8?B?0JDQvdC00YDQtdC5INCa0YDRi9C70L7RgdC+0LI=?= <krylosov.andrew@gmail.com>
Date: Thu, 22 Jan 2026 13:26:15 +0300
Message-ID: <CA+nn4-oAufw+AyjjKyzEd+VeH4O8PP+5YzWtSC+jHa1wUnizhA@mail.gmail.com>
Subject: =?UTF-8?Q?=5BTool=5D_pg=2Dstatus_=E2=80=94_lightweight_microservice_for_ch?=
	=?UTF-8?Q?ecking_PostgreSQL_host_status?=
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000029fc870648f7799a"
Archived-At: <https://www.postgresql.org/message-id/CA%2Bnn4-oAufw%2BAyjjKyzEd%2BVeH4O8PP%2B5YzWtSC%2BjHa1wUnizhA%40mail.gmail.com>
Precedence: bulk

--00000000000029fc870648f7799a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi all!

I'd like to share a small open=E2=80=91source project I've been working on:
[pg-status](https://github.com/krylosov-aa/pg-status).

pg-status is a lightweight microservice (sidecar) that helps you instantly
determine the status of your PostgreSQL hosts: whether they are alive,
which one is the master, which ones are replicas, and how far each replica
is lagging behind the master.

It's designed to run alongside your main application. It's lightweight,
resource=E2=80=91efficient, and delivers high performance. You can query it=
 on
every request without noticeable overhead.

pg-status polls your database hosts in the background at a configurable
interval and exposes an HTTP interface that you can use to retrieve hosts
matching given conditions.

I originally built it to speed up master detection in a multi=E2=80=91host =
setup
where DNS failover was too slow, but it's also handy for proxy setups or
custom load=E2=80=91balancing logic.

More information is available on GitHub:
https://github.com/krylosov-aa/pg-status

Feedback and discussion are very welcome. I'd love to hear your thoughts!

Best regards,
Andrei Krylosov

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

<div dir=3D"ltr">Hi all!<br><br>I&#39;d like to share a small open=E2=80=91=
source project I&#39;ve been working on: [pg-status](<a href=3D"https://git=
hub.com/krylosov-aa/pg-status">https://github.com/krylosov-aa/pg-status</a>=
).<br><br>pg-status is a lightweight microservice (sidecar) that helps you =
instantly determine the status of your PostgreSQL hosts: whether they are a=
live, which one is the master, which ones are replicas, and how far each re=
plica is lagging behind the master.<br><br>It&#39;s designed to run alongsi=
de your main application. It&#39;s lightweight, resource=E2=80=91efficient,=
 and delivers high performance. You can query it on every request without n=
oticeable overhead.<br><br>pg-status polls your database hosts in the backg=
round at a configurable interval and exposes an HTTP interface that you can=
 use to retrieve hosts matching given conditions.<br><br>I originally built=
 it to speed up master detection in a multi=E2=80=91host setup where DNS fa=
ilover was too slow, but it&#39;s also handy for proxy setups or custom loa=
d=E2=80=91balancing logic.<br><br>More information is available on GitHub: =
<a href=3D"https://github.com/krylosov-aa/pg-status">https://github.com/kry=
losov-aa/pg-status</a><br><br>Feedback and discussion are very welcome. I&#=
39;d love to hear your thoughts!<br><br>Best regards, =C2=A0<br>Andrei Kryl=
osov<br></div>

--00000000000029fc870648f7799a--