| 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: | Whole Thread | Raw Message | 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
------------------------------------------------------------------------------
| 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 |