Date: Fri, 20 Dec 2024 22:49:35 +0000 (UTC)
From: Y_Bharani_mbsv <mailbsv@yahoo.com>
To: pgsql-general <pgsql-general@postgresql.org>, 
	Ron Johnson <ronljohnsonjr@gmail.com>
Message-ID: <1507580215.1602027.1734734975251@mail.yahoo.com>
In-Reply-To: <CANzqJaB6-FakfpM8tXJ_11gvTo65ep8M-oS4GSC1XxfBPPBZHg@mail.gmail.com>
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> <CANzqJaB6-FakfpM8tXJ_11gvTo65ep8M-oS4GSC1XxfBPPBZHg@mail.gmail.com>
Subject: Re: any tips to have restricted inbound and getting connected with
 postgresql dB
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_1602026_936940914.1734734975250"
Content-Length: 4247
Archived-At: <https://www.postgresql.org/message-id/1507580215.1602027.1734734975251%40mail.yahoo.com>
Precedence: bulk

------=_Part_1602026_936940914.1734734975250
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 TQ
    On Friday, December 20, 2024 at 03:26:30 PM EST, Ron Johnson <ronljohns=
onjr@gmail.com> wrote: =20
=20
 On Fri, Dec 20, 2024 at 2:25=E2=80=AFPM Y_Bharani_mbsv <mailbsv@yahoo.com>=
 wrote:
 =C2=A0TeamI 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 p=
ostgres db ,during my specific time window

1. Create a pg_hba_maintmode.conf with only the relevant hosts in it.2. Cop=
y 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 ki=
ll 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! =20
------=_Part_1602026_936940914.1734734975250
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydp92ebd59cyahoo-style-wrap" style=
=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px=
;"><div></div>
        <div dir=3D"ltr" data-setdir=3D"false">TQ</div><div><br></div>
       =20
        </div><div id=3D"ydpbc85d8f4yahoo_quoted_5545851978" class=3D"ydpbc=
85d8f4yahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Friday, December 20, 2024 at 03:26:30 PM EST, Ro=
n Johnson &lt;ronljohnsonjr@gmail.com&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div id=3D"ydpbc85d8f4yiv4094156964"><div><div dir=3D"=
ltr"><div id=3D"ydpbc85d8f4yiv4094156964yqtfd99013" class=3D"ydpbc85d8f4yiv=
4094156964yqt0773661061"><div dir=3D"ltr">On Fri, Dec 20, 2024 at 2:25=E2=
=80=AFPM Y_Bharani_mbsv &lt;<a shape=3D"rect" href=3D"mailto:mailbsv@yahoo.=
com" rel=3D"nofollow" target=3D"_blank">mailbsv@yahoo.com</a>&gt; wrote:</d=
iv><div class=3D"ydpbc85d8f4yiv4094156964gmail_quote ydpbc85d8f4yiv40941569=
64gmail_quote_container"><blockquote style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex;" class=3D"ydpbc85d8f4y=
iv4094156964gmail_quote"><div><div style=3D"font-family:Helvetica, Arial, s=
ans-serif;font-size:16px;"><div></div>
        <div dir=3D"ltr">&nbsp;Team</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 clear=3D"none"></div><div dir=3D"ltr">Ho=
w to restrict all the application layer , not to get connected with the pos=
tgres db ,</div><div dir=3D"ltr">during my specific time window</div></div>=
</div></blockquote><div></div></div></div><div><br clear=3D"none"></div><di=
v>1. Create a pg_hba_maintmode.conf with only the relevant hosts in it.</di=
v><div>2. Copy pg_hba.conf to pg_hba_multi.conf.</div><div>3. Copy pg_hba_m=
aintmode.conf to pg_hba.conf.</div><div>4. pg_ctl reload.</div><div>5. Use =
pg_stat_activity and pg_cancel_backend() to kill the application connection=
s.</div><div>6. Do your work.</div><div>7. Copy pg_hba_multi.conf to pg_hba=
.conf.</div><div>8. pg_ctl reload</div><div><br clear=3D"none"></div><div>O=
r... just shut down the user application.</div><div><br clear=3D"none"></di=
v><span class=3D"ydpbc85d8f4yiv4094156964gmail_signature_prefix">-- </span>=
<br clear=3D"none"><div dir=3D"ltr" class=3D"ydpbc85d8f4yiv4094156964gmail_=
signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<di=
v>Don't boil me, I'm still alive.<br clear=3D"none"><div><div>&lt;Redacted&=
gt; lobster!</div></div></div></div></div></div><div id=3D"ydpbc85d8f4yiv40=
94156964yqtfd66681" class=3D"ydpbc85d8f4yiv4094156964yqt0773661061">
</div></div></div></div>
            </div>
        </div></body></html>
------=_Part_1602026_936940914.1734734975250--