Request a Demo
Home   >   mailing lists

Re: Postgresql database terminates abruptly with too many open files error - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgresql database terminates abruptly with too many open files error
Date
Msg-id 679341.1736864393@sss.pgh.pa.us
Whole thread Raw
In response to Postgresql database terminates abruptly with too many open files error  (Sri Mrudula Attili <sri@ebi.ac.uk>)
Responses Re: Postgresql database terminates abruptly with too many open files error
List pgsql-general
Tree view 
Sri Mrudula Attili <sri@ebi.ac.uk> 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 65000.

I'm suspecting that you either need to increase that, decrease
max_files_per_process (which defaults to 1000), or decrease
max_connections.

            regards, tom lane

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Postgresql database terminates abruptly with too many open files error
Next
From: Adrian Klaver
Date:
Subject: Re: Intermittent errors when fetching cursor rows on PostgreSQL 16