MIME-Version: 1.0
References: 
 <CANnOdgb=p9mLcg=5BMJ76yEZ+RYR7WHgS1VJRf8EY5VvOcf3ng@mail.gmail.com>
In-Reply-To: 
 <CANnOdgb=p9mLcg=5BMJ76yEZ+RYR7WHgS1VJRf8EY5VvOcf3ng@mail.gmail.com>
From: Imran Khan <imran.k.23@gmail.com>
Date: Fri, 11 Oct 2024 23:21:57 +0300
Message-ID: 
 <CAC4eXDgnUn2zGJewcB-Lit4qW7GnN6omQxu7==AZ3Fhyb0wX8Q@mail.gmail.com>
Subject: Re: Unknown temp directories and library files
To: Priancka Chatz <pc9926@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f7213a0624393dc5"
Archived-At: 
 <https://www.postgresql.org/message-id/CAC4eXDgnUn2zGJewcB-Lit4qW7GnN6omQxu7%3D%3DAZ3Fhyb0wX8Q%40mail.gmail.com>
Precedence: bulk

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

Hi,

 Try to first restrict the access of localhost and assign a password for
postgres which is known to you. Then ask Linux team or server team to share
logs of logins and history of root. Finally, restart the instance to clear
pgsql_tmp dir.

Thanks,
Imran

On Fri, Oct 11, 2024, 1:20=E2=80=AFPM Priancka Chatz <pc9926@gmail.com> wro=
te:

> Hi admins,
>
> I am observing a new/unknown behavior on some of my instances. My postgre=
s
> Data directory path is /home/postgres/pgdata/pgroot/data. And I see a tem=
p
> directory present inside /home/postgres/pgdata which has 100s of director=
y
> underneath it and inside each directory some library files related to
> Psycopg2. Not sure what these files are and why it is getting created. I =
am
> attaching screenshots for reference.
> Can anyone shed some light or direct me to any links to troubleshoot this=
?
>
> Regards,
> Priyanka
>

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

<div dir=3D"auto">Hi,<div dir=3D"auto"><br></div><div dir=3D"auto">=C2=A0Tr=
y to first restrict the access of localhost and assign a password for postg=
res which is known to you. Then ask Linux team or server team to share logs=
 of logins and history of root. Finally, restart the instance to clear pgsq=
l_tmp dir.=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thanks,=
</div><div dir=3D"auto">Imran</div></div><br><div class=3D"gmail_quote"><di=
v dir=3D"ltr" class=3D"gmail_attr">On Fri, Oct 11, 2024, 1:20=E2=80=AFPM Pr=
iancka Chatz &lt;<a href=3D"mailto:pc9926@gmail.com">pc9926@gmail.com</a>&g=
t; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 =
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi admin=
s,<div><br></div><div>I am observing a new/unknown behavior on some of my i=
nstances. My postgres Data directory path is /home/postgres/pgdata/pgroot/d=
ata. And I see a temp directory present inside /home/postgres/pgdata which =
has 100s of directory underneath it and inside each directory some library =
files related to Psycopg2. Not sure what these files are and why it is gett=
ing created. I am attaching screenshots for reference.</div><div>Can anyone=
 shed some light or direct me to any links to troubleshoot this?</div><div>=
<br></div><div>Regards,</div><div>Priyanka</div></div>
</blockquote></div>

--000000000000f7213a0624393dc5--