Postgres Pro
Downloads
Home   >   mailing lists

Re: Too many Open files error for postgres - Mailing list pgsql-admin

From Tom Lane
Subject Re: Too many Open files error for postgres
Date
Msg-id 8751.1466518180@sss.pgh.pa.us
Whole thread Raw
In response to Too many Open files error for postgres  ("Geo P.C." <pcgeopc@gmail.com>)
Responses Re: Too many Open files error for postgres  ("Geo P.C." <pcgeopc@gmail.com>)
List pgsql-admin
Tree view 
"Geo P.C." <pcgeopc@gmail.com> writes:
> In Ubuntu 14.04 server on a JAVA Application we are getting Too many Open
> files error for postgres.

How many server processes are you trying to use?  I suspect you are
hitting the system-wide file table limit not the per-process limit.
Best answer might be to decrease PG's max_files_per_process setting
rather than try to persuade the kernel to increase its limit.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Geo P.C."
Date:
Subject: Too many Open files error for postgres
Next
From: Slavcho Trnkovski
Date:
Subject: Re: WAL retention