Re: Too many open files in system

From: mlw <markw(at)mohawksoft(dot)com>
To: ryan(at)paymentalliance(dot)net
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Too many open files in system
Date: 2001-04-16 12:22:44
Message-ID: 3ADAE414.6CE95BCC@mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ryan(at)paymentalliance(dot)net wrote:
>
> What does this error mean - and how can I avoid it in the future?
>
> postmaster: StreamConnection: accept: Too many open files in system
>
> Any help would be much appreciated!
>
> Ryan Mahoney

It would be helpful if you could give more information, but if you are running
Linux, you may need to bump up the maximum number of open files.

cat /proc/sys/fs/file-nr

Will spit out three numbers:

aaaa bbbb cccc

aaaa is the maximum number of files you have opened.
bbbb is the number of files which are currently open
cccc is the system configured maximum number of files.

if aaaa is very close to cccc than you should adjust the maximum number of
files your system can use

echo 16384 > /proc/sys/fs/file-max

where 16384 is the desired number.

--
I'm not offering myself as an example; every life evolves by its own laws.
------------------------
http://www.mohawksoft.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Allan C Huffman 2001-04-16 14:48:07 RedHat/Postgres.pm Error
Previous Message Lincoln Yeoh 2001-04-16 07:21:21 Re: Re: Hey guys, check this out.