Re: More on Too Many Open Files... NetBSD

From: "Ian Harding" <ianh(at)tpchd(dot)org>
To: <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: More on Too Many Open Files... NetBSD
Date: 2001-12-18 22:44:19
Message-ID: sc1f56c0.021@mail.tpchd.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The command from inside the pltcl function? It is wrapped in a loop that should run about 200 times and is

exec echo $msg | mail -s "New Timecard System" -c "ianh(at)tpchd(dot)org" $U(username)@tpchd.org

where msg is a little message.

I start postgresql with default values.

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding(at)tpchd(dot)org

>>> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> 12/18/01 02:30PM >>>
> This looks like all is well? Anyway, I still get
>
> ERROR: pltcl: couldn't create pipe: too many open files
>
> Thanks, I hope this is the right place to post, I figure I am
> looking for someone who knows what PG needs and what NetBSD is
> offering it...

Ulimit controls the maximum number of open files per process while
sysctl controls the maximum number of open files system-wide. I would
look at sysctl. However, if the number of system open files is low, I
would think you would see problems in more places. Is it possible your
command-line is trying to open an infinite number of files? Can you
send us your command line?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Fisher 2001-12-18 22:51:20 another foreign key question
Previous Message Andrew G. Hammond 2001-12-18 22:39:31 Re: Is there a PostgresQL equivalent to the DESCRIBE