Feedback-ID: i76984098:Fastmail
Message-ID: <055092f1-63d4-443f-9fff-afa56640e412@aklaver.com>
Date: Sun, 13 Oct 2024 12:42:32 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Unknown temp directories and library files
To: Priancka Chatz <pc9926@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <CANnOdgbXRyVpynHhbWEJedR=N9m6=kAi1qUGcJbkHOsq027=cA@mail.gmail.com>
 <3217758f-a9e0-4ed3-b78b-0ab2622279e0@aklaver.com>
 <CANnOdgb820nK=EHajqf7LrWezyif+8vht_DCbrD=VB+1QQkMhQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CANnOdgb820nK=EHajqf7LrWezyif+8vht_DCbrD=VB+1QQkMhQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/055092f1-63d4-443f-9fff-afa56640e412%40aklaver.com>
Precedence: bulk

On 10/13/24 11:34, Priancka Chatz wrote:
> Hi Adrian,
> 
> There is patroni and pgqd running on the server. So possibly these are 
> using psycopg2.

You are  going to have investigate what is actually repeatedly 
installing psycopg2-binary and psycopg2.

Steps I can think of to do this:

1) Sort the temp directories by timestamp and see if there is a pattern.

2) Look at the OS system log for entries at the above timestamps.

3) Do same for Postgres log.

> 
> Regards,
> Priyanka
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com