Re: Unknown temp directories and library files

Hi Adrian,

There is patroni and pgqd running on the server. So possibly these are
using psycopg2.

Regards,
Priyanka

On Sun, 13 Oct 2024 at 6:01 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 10/10/24 11:36, Priancka Chatz wrote:
> > Hi admins,
> >
> > I am observing a new/unknown behavior on some of my instances. My
> > postgres Data directory path is /home/postgres/pgdata/pgroot/data. 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 getting
> > created. However, the only pattern I found is wherever Postgres is down
> > this behavior is seen.
>
> They are coming from an install of psycopg2-binary:
>
> pip install psycopg2-binary
>
> ll lib/python3.12/site-packages/psycopg2_binary.libs/
> total 6944
> drwxrwxr-x 2 aklaver aklaver 4096 Oct 13 08:55 ./
> drwxrwxr-x 348 aklaver aklaver 20480 Oct 13 08:55 ../
> -rwxrwxr-x 1 aklaver aklaver 17497 Oct 13 08:55
> libcom_err-2abe824b.so.2.1*
> -rwxrwxr-x 1 aklaver aklaver 3133185 Oct 13 08:55
> libcrypto-0628e7d4.so.1.1*
> -rwxrwxr-x 1 aklaver aklaver 345209 Oct 13 08:55
> libgssapi_krb5-497db0c6.so.2.2*
> -rwxrwxr-x 1 aklaver aklaver 219953 Oct 13 08:55
> libk5crypto-b1f99d5c.so.3.1*
> -rwxrwxr-x 1 aklaver aklaver 17913 Oct 13 08:55
> libkeyutils-dfe70bd6.so.1.5*
> -rwxrwxr-x 1 aklaver aklaver 1018953 Oct 13 08:55
> libkrb5-fcafa220.so.3.3*
> -rwxrwxr-x 1 aklaver aklaver 76873 Oct 13 08:55
> libkrb5support-d0bcff84.so.0.1*
> -rwxrwxr-x 1 aklaver aklaver 60977 Oct 13 08:55
> liblber-5a1d5ae1.so.2.0.200*
> -rwxrwxr-x 1 aklaver aklaver 447329 Oct 13 08:55
> libldap-5d2ff197.so.2.0.200*
> -rwxrwxr-x 1 aklaver aklaver 406817 Oct 13 08:55
> libpcre-9513aab5.so.1.2.0*
> -rwxrwxr-x 1 aklaver aklaver 370777 Oct 13 08:55 libpq-e8a033dd.so.5.16*
> -rwxrwxr-x 1 aklaver aklaver 119217 Oct 13 08:55
> libsasl2-883649fd.so.3.0.0*
> -rwxrwxr-x 1 aklaver aklaver 178337 Oct 13 08:55
> libselinux-0922c95c.so.1*
> -rwxrwxr-x 1 aklaver aklaver 646065 Oct 13 08:55 libssl-3e69114b.so.1.1*
>
>
> Looks like something is setting up psycopg2-binary and psycopg2 as part
> of some script/tool/orm/etc in your $DATA directory.
>
> Are you using something that uses psycopg2 as the client library?
>
> >
> > I am attaching screenshots for reference.
> >
> > Can anyone shed some light or direct me to any links to troubleshoot
> this?
> >
> > Regards,
> > Priyanka
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>