Re: [GENERAL] Fw: Spin lock error - Mailing list pgsql-general

From Lincoln Spiteri
Subject Re: [GENERAL] Fw: Spin lock error
Date
Msg-id 99121509340300.03978@voltaire.kir.st.com
Whole thread Raw
In response to Fw: Spin lock error  ("Differentiated Software Solutions Pvt. Ltd." <diffs@vsnl.com>)
List pgsql-general

On Wed, 15 Dec 1999, diffs@vsnl.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.spiteri@st.com

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

pgsql-general by date:

Previous
From: "Vince DiCiero"
Date:
Subject: RE: [GENERAL] Access rescrictions
Next
From: Rodolphe QUIEDEVILLE
Date:
Subject: ORDER BY Problem