Re: [GENERAL] Fw: Spin lock error

From: Lincoln Spiteri <lincoln(dot)spiteri(at)st(dot)com>
To: diffs(at)vsnl(dot)com, scrappy(at)hub(dot)org, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Fw: Spin lock error
Date: 1999-12-15 08:31:37
Message-ID: 99121509340300.03978@voltaire.kir.st.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 15 Dec 1999, diffs(at)vsnl(dot)com wrote:

>6184 p2 R 0:00 /usr/local/bin/postgres localhost postgres adcept SELECT
>20964 p6 S 0:00 su - postgres
>23112 p4 S 0:00 su - postgres
>27664 p2 R 0:03 /usr/local/bin/postmaster -i
>
>bash: /bin/ps: Too many open files in system

I was getting this recently on a production server, I solved it by increasing
the number of file descriptors per process in the kernel. Do a ulimit -a to see
what your limits are.

Lincoln

--
------------------------------------------------------------------------------

Lincoln Spiteri

Manufacturing Systems
STMicroelectronics, Malta

e-mail: lincoln(dot)spiteri(at)st(dot)com

------------------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rodolphe QUIEDEVILLE 1999-12-15 09:30:22 ORDER BY Problem
Previous Message Vince DiCiero 1999-12-15 06:29:13 RE: [GENERAL] Access rescrictions