Date: Fri, 20 Dec 2024 22:51:02 +0000 (UTC)
From: Bharani SV-forum <esteembsv-forum@yahoo.com>
To: pgsql-general <pgsql-general@postgresql.org>, 
	Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <2036867199.5856152.1734735063013@mail.yahoo.com>
In-Reply-To: <f37731a5-80bf-45d8-b699-587652f34b00@aklaver.com>
References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.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> <f37731a5-80bf-45d8-b699-587652f34b00@aklaver.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_5856151_471473661.1734735063012"
Content-Length: 3451
Archived-At: <https://www.postgresql.org/message-id/2036867199.5856152.1734735063013%40mail.yahoo.com>
Precedence: bulk

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

 I am having heavy polling into the database and need to perform certain ta=
sks without any application interference.

    On Friday, December 20, 2024 at 03:13:21 PM EST, Adrian Klaver <adrian.=
klaver@aklaver.com> wrote: =20
=20
 On 12/20/24 11:25, Y_Bharani_mbsv wrote:
>=C2=A0 =C2=A0Team
> I have the need to have postgresql db running in multiuser mode and do=20
> my needed tasks for few mins.

What are the tasks and why do you think they can't be run concurrently=20
with other users?

>=20
> How to restrict all the application layer , not to get connected with=20
> the postgres db ,
> during my specific time window
> I am aware of their application layer - username
>=20
> Changing password is the last option
>=20
> Any tips
>=20

--=20
Adrian Klaver
adrian.klaver@aklaver.com


 =20
------=_Part_5856151_471473661.1734735063012
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydpe25840fbyahoo-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">I am having heavy polling in=
to the database and need to perform certain tasks without any application i=
nterference.</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div><br=
></div>
       =20
        </div><div id=3D"ydpee80b6yahoo_quoted_5191469542" class=3D"ydpee80=
b6yahoo_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:13:21 PM EST, Ad=
rian Klaver &lt;adrian.klaver@aklaver.com&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div dir=3D"ltr">On 12/20/24 11:25, Y_Bharani_mbsv wro=
te:<br clear=3D"none">&gt;&nbsp; &nbsp;Team<br clear=3D"none">&gt; I have t=
he need to have postgresql db running in multiuser mode and do <br clear=3D=
"none">&gt; my needed tasks for few mins.<br clear=3D"none"><br clear=3D"no=
ne">What are the tasks and why do you think they can't be run concurrently =
<br clear=3D"none">with other users?<div class=3D"ydpee80b6yqt8877715712" i=
d=3D"ydpee80b6yqtfd12256"><br clear=3D"none"><br clear=3D"none">&gt; <br cl=
ear=3D"none">&gt; How to restrict all the application layer , not to get co=
nnected with <br clear=3D"none">&gt; the postgres db ,<br clear=3D"none">&g=
t; during my specific time window<br clear=3D"none">&gt; I am aware of thei=
r application layer - username<br clear=3D"none">&gt; <br clear=3D"none">&g=
t; Changing password is the last option<br clear=3D"none">&gt; <br clear=3D=
"none">&gt; Any tips</div><br clear=3D"none">&gt; <br clear=3D"none"><br cl=
ear=3D"none">-- <br clear=3D"none">Adrian Klaver<br clear=3D"none"><a shape=
=3D"rect" href=3D"mailto:adrian.klaver@aklaver.com" rel=3D"nofollow" target=
=3D"_blank">adrian.klaver@aklaver.com</a><div class=3D"ydpee80b6yqt88777157=
12" id=3D"ydpee80b6yqtfd74511"><br clear=3D"none"><br clear=3D"none"><br cl=
ear=3D"none"><br clear=3D"none"></div></div></div>
            </div>
        </div></body></html>
------=_Part_5856151_471473661.1734735063012--