Postgresql database terminates abruptly with toomay open files error

Sri Mrudula Attili <sri@ebi.ac.uk>

From: Sri Mrudula Attili <sri@ebi.ac.uk>
To: pgsql-in-general@postgresql.org
Date: 2025-01-14T12:52:34Z
Lists: pgsql-general
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

< 2025-01-14 11:37:20.724 GMT >FATAL:  epoll_create1 failed: Too many 
open files in system


The number of allowed openfiles at OS level are 65000. even then we see 
these all these being utilised and causing the database to terminate.


Is there a way we could avoid this.


Thanks,

Sri