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 PM Priancka Chatz <pc9926@gmail.com> 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. I am attaching screenshots for reference.
Can anyone shed some light or direct me to any links to troubleshoot this?
