From: Emile Amewoto <emileam@yahoo.com>
Message-Id: <6B782D94-E9A9-48D3-829F-0F1DF9585189@yahoo.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_79B07E70-327A-4AAE-9A96-2D630F4690DF"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.700.6\))
Subject: Re: tell master to tell it's the master - ?
Date: Fri, 18 Aug 2023 11:34:47 +0200
In-Reply-To: <3e072d55-a260-d4aa-0ea7-0ce395e359eb@yahoo.co.uk>
Cc: pgsql-admin@lists.postgresql.org
To: lejeczek <peljasz@yahoo.co.uk>
References: <3e072d55-a260-d4aa-0ea7-0ce395e359eb.ref@yahoo.co.uk>
 <3e072d55-a260-d4aa-0ea7-0ce395e359eb@yahoo.co.uk>
Content-Length: 2535
Archived-At: 
 <https://www.postgresql.org/message-id/6B782D94-E9A9-48D3-829F-0F1DF9585189%40yahoo.com>
Precedence: bulk


--Apple-Mail=_79B07E70-327A-4AAE-9A96-2D630F4690DF
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

Hi Lejeczek,
What are you using to control your cluster?
If you are using patroni, you can use regex to grep the Leader or if you =
are not using any cluster manager you can do:

SELECT Count(pid))=20
          FROM pg_stat_activity WHERE wait_event IS NOT NULL AND =
backend_type =3D =E2=80=98walsender'
The master will always have walsender process and the standby walreiver

Regards,
Emile

> On 18 Aug 2023, at 11:07, lejeczek <peljasz@yahoo.co.uk> wrote:
>=20
> Hi guys.
>=20
> Is it possible to configure pgSQL to announce it's being a master and =
not querying it?
> I was hoping for a file whose existence or content would confirm that =
and would be generated/created by pqSQL itself - am I too naive?
>=20
> many thanks, L.


--Apple-Mail=_79B07E70-327A-4AAE-9A96-2D630F4690DF
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"overflow-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;">Hi =
Lejeczek,<div>What are you using to control your cluster?</div><div>If =
you are using patroni, you can use regex to grep the Leader or if you =
are not using any cluster manager you can =
do:</div><div><br></div><div><div>SELECT =
Count(pid))&nbsp;</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM =
pg_stat_activity WHERE wait_event IS NOT NULL AND backend_type =3D =
=E2=80=98walsender'</div><div>The master will always have walsender =
process and the standby =
walreiver</div><div><br></div><div>Regards,</div><div>Emile</div><div><br>=
<blockquote type=3D"cite"><div>On 18 Aug 2023, at 11:07, lejeczek =
&lt;peljasz@yahoo.co.uk&gt; wrote:</div><br =
class=3D"Apple-interchange-newline"><div>
 =20

    <meta http-equiv=3D"content-type" content=3D"text/html; =
charset=3DUTF-8">
 =20
  <div>
    <font size=3D"2"><font face=3D"Courier 10 Pitch">Hi guys.<br>
        <br>
        Is it possible to configure pgSQL to announce it's being a
        master and not querying it?<br>
        I was hoping for a file whose existence or content would confirm
        that and would be generated/created by pqSQL itself - am I too
        naive?<br>
        <br>
        many thanks, L.<br>
      </font></font>
  </div>

</div></blockquote></div><br></div></body></html>=

--Apple-Mail=_79B07E70-327A-4AAE-9A96-2D630F4690DF--