Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45600=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bFMN8-0001c7-JL
	for pgsql-admin@arkaria.postgresql.org; Tue, 21 Jun 2016 14:09:46 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45600=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bFMN8-0004m3-32
	for pgsql-admin@arkaria.postgresql.org; Tue, 21 Jun 2016 14:09:46 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1bFMN7-0004lw-LC
	for pgsql-admin@postgresql.org; Tue, 21 Jun 2016 14:09:45 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1bFMN5-0002mP-3o
	for pgsql-admin@postgresql.org; Tue, 21 Jun 2016 14:09:45 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id u5LE9eVY008752;
	Tue, 21 Jun 2016 10:09:40 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Geo P.C." <pcgeopc@gmail.com>
cc: pgsql-admin@postgresql.org
Subject: Re: Too many Open files error for postgres
In-reply-to: 
 <CAKtc8vXh7NvP_qWj8EqqorPY97bvxSaX3h5u7a9PptRFHW5x7g@mail.gmail.com>
References: 
 <CAKtc8vXh7NvP_qWj8EqqorPY97bvxSaX3h5u7a9PptRFHW5x7g@mail.gmail.com>
Comments: In-reply-to "Geo P.C." <pcgeopc@gmail.com>
	message dated "Tue, 21 Jun 2016 19:21:40 +0530"
Date: Tue, 21 Jun 2016 10:09:40 -0400
Message-ID: <8751.1466518180@sss.pgh.pa.us>
X-Pg-Spam-Score: -3.3 (---)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

"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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin