On 2025-01-15 11:42:30 +, Sri Mrudula Attili wrote:
> The max_connections =200 and max_files_per_process =1000 as you mentioned.
>
> So should a max_files_per_process =500 helps?
>
>
> I could see from the number of connections to the databaseis not exceeding
> 20. But still these 20 are cau
-- Forwarded message -
From: Sri Mrudula Attili
Date: Wed, 15 Jan, 2025, 17:12
Subject: Re: Postgresql database terminates abruptly with too many open
files error
To: Tom Lane
Cc:
Hello Tom,
The max_connections =200 and max_files_per_process =1000 as you mentioned.
So
Hello Tom,
The max_connections =200 and max_files_per_process =1000 as you mentioned.
So should a max_files_per_process =500 helps?
I could see from the number of connections to the databaseis not
exceeding 20. But still these 20 are causing all the damage or using up
all the openfiles quot
Sri Mrudula Attili writes:
> We have a postgresql VDB(virtual database- Delphix) that keeps
> terminating due "to too many open files".
What do you have max_connections set to, and how many actually-live
server processes are there typically?
> The number of allowed openfiles at OS level are 6
On Tue, Jan 14, 2025 at 7:58 AM Sri Mrudula Attili wrote:
> Hello Team,
>
> We have a postgresql VDB(virtual database- Delphix) that keeps
> terminating due "to too many open files".
>
> Below are few alerts that we could see from the postgresql.log
>
>
> < 2025-01-14 11:37:20.724 GMT >LOG: ou
Hello,
Have you checked something like lsof to see open file descriptors to see?
Cheers,
frank
Am 14.01.25 um 13:58 schrieb Sri Mrudula Attili:
Hello Team,
We have a postgresql VDB(virtual database- Delphix) that keeps terminating due "to
too many open files".
Below are few alerts that w
Hello Team,
We have a postgresql VDB(virtual database- Delphix) that keeps
terminating due "to too many open files".
Below are few alerts that we could see from the postgresql.log
< 2025-01-14 11:37:20.724 GMT >LOG: out of file descriptors: Too many
open files in system; release and retry
