Re: Postgresql database terminates abruptly with too many open files error

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