| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Toma Vailikit <toma(at)nutz(dot)org> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Too many open files in system |
| Date: | 2000-10-17 15:30:23 |
| Message-ID: | Pine.BSF.4.10.10010170828500.76155-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)bigpanda(dot)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?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michel Decima | 2000-10-18 16:28:05 | Re: pltcl, linker and statistical functions |
| Previous Message | Toma Vailikit | 2000-10-17 13:19:15 | Too many open files in system |