Re: Too many open files in system - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Too many open files in system
Date
Msg-id Pine.BSF.4.10.10010170828500.76155-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Too many open files in system  ("Toma Vailikit" <toma@nutz.org>)
List pgsql-admin
It sounds as if postgres is running into the kernel's
system open files limit.  What is it set to, and how
many backends are running when this starts happening?

Stephan Szabo
sszabo@bigpanda.com

On Tue, 17 Oct 2000, Toma Vailikit wrote:

> I run a pretty heavily visited web site and am using postgres aa the SQL
> database on it. I'm beta testing some stuff and after a while Postgres dies
> like a dog and I get the following entries in the log:
>
> FATAL 1:  File '/usr/local/pgsql/data/PG_VERSION' does not exist or no read
> permission.
> postmaster: StreamConnection: accept: Too many open files in system
>
> I can reproduce this by just blasting away at the refresh button on a
> browser. Anyone have any ideas?
>


pgsql-admin by date:

Previous
From: "Toma Vailikit"
Date:
Subject: Too many open files in system
Next
From: Alexey Rodriguez Yakushev
Date:
Subject: Re: pg_hba.conf problems with Postgresql 7.0.2