Sri Mrudula Attili <s...@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
