MIME-Version: 1.0
References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com>
 <CANzqJaAda4nZbkG=c+72ry5GdaxrJ6Jzr6fz1quhq8tTfaX1Pg@mail.gmail.com>
 <07ab2d83-ffe5-4bec-9626-22a68f732579@aklaver.com> <273a88dc-4134-47d5-bc19-30ff5f97926c@aklaver.com>
 <CANzqJaC1Uk4H=55vV_jbFYMuD1f9Bb_4Y9WKvkZA3bt92bEUnw@mail.gmail.com>
 <498dfb34-4dd7-4f48-8188-355e1488d7e6@aklaver.com> <1061066336.5835157.1733316137292@mail.yahoo.com>
 <a779ef21-f04d-4a51-83d3-51632b0fb3fa@aklaver.com> <1918413683.2239751.1733944364448@mail.yahoo.com>
 <037a8338-3434-47d4-aaad-ef186d4d3250@aklaver.com> <101139100.4053671.1734383960480@mail.yahoo.com>
 <dece41b2-44bd-4b0c-9b3e-57b0adfaf1bb@aklaver.com> <1875422740.4095620.1734388259706@mail.yahoo.com>
 <aa16f097-fadd-439c-a58e-e2229d92bc5b@aklaver.com> <1528119631.4096246.1734390318281@mail.yahoo.com>
 <2033286177.1733661.1734651404850@mail.yahoo.com> <8833d8c7-3713-4d6f-9eab-35270e769564@aklaver.com>
 <1392047062.5689697.1734710997053@mail.yahoo.com> <adc3d09b-440c-48c7-9d72-0f247f27feff@aklaver.com>
 <783439164.5695290.1734713539262@mail.yahoo.com> <928427177.4710979.1734722745840@mail.yahoo.com>
In-Reply-To: <928427177.4710979.1734722745840@mail.yahoo.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 20 Dec 2024 15:25:57 -0500
Message-ID: <CANzqJaB6-FakfpM8tXJ_11gvTo65ep8M-oS4GSC1XxfBPPBZHg@mail.gmail.com>
Subject: Re: any tips to have restricted inbound and getting connected with
 postgresql dB
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fd709b0629b97417"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaB6-FakfpM8tXJ_11gvTo65ep8M-oS4GSC1XxfBPPBZHg%40mail.gmail.com>
Precedence: bulk

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

On Fri, Dec 20, 2024 at 2:25=E2=80=AFPM Y_Bharani_mbsv <mailbsv@yahoo.com> =
wrote:

>  Team
> I have the need to have postgresql db running in multiuser mode and do my
> needed tasks for few mins.
>
> How to restrict all the application layer , not to get connected with the
> postgres db ,
> during my specific time window
>

1. Create a pg_hba_maintmode.conf with only the relevant hosts in it.
2. Copy pg_hba.conf to pg_hba_multi.conf.
3. Copy pg_hba_maintmode.conf to pg_hba.conf.
4. pg_ctl reload.
5. Use pg_stat_activity and pg_cancel_backend() to kill the application
connections.
6. Do your work.
7. Copy pg_hba_multi.conf to pg_hba.conf.
8. pg_ctl reload

Or... just shut down the user application.

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Dec 20, 2024 at 2:25=E2=80=AFPM Y=
_Bharani_mbsv &lt;<a href=3D"mailto:mailbsv@yahoo.com">mailbsv@yahoo.com</a=
>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px=
 solid rgb(204,204,204);padding-left:1ex"><div><div style=3D"font-family:&q=
uot;Helvetica Neue&quot;,Helvetica,Arial,sans-serif;font-size:16px"><div></=
div>
        <div dir=3D"ltr">=C2=A0Team</div><div dir=3D"ltr">I have the need t=
o have postgresql db running in multiuser mode and do my needed tasks for f=
ew mins.</div><div dir=3D"ltr"><br></div><div dir=3D"ltr">How to restrict a=
ll the application layer , not to get connected with the postgres db ,</div=
><div dir=3D"ltr">during my specific time window</div></div></div></blockqu=
ote><div></div></div><div><br></div><div>1. Create a pg_hba_maintmode.conf =
with only the relevant hosts in it.</div><div>2. Copy pg_hba.conf to pg_hba=
_multi.conf.</div><div>3. Copy pg_hba_maintmode.conf to pg_hba.conf.</div><=
div>4. pg_ctl reload.</div><div>5. Use pg_stat_activity and pg_cancel_backe=
nd() to kill the application connections.</div><div>6. Do your work.</div><=
div>7. Copy pg_hba_multi.conf to pg_hba.conf.</div><div>8. pg_ctl reload</d=
iv><div><br></div><div>Or... just shut down the user application.</div><div=
><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D=
"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;,=
 and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div=
>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--000000000000fd709b0629b97417--