Re: More on Too Many Open Files... NetBSD - Mailing list pgsql-general

From Ian Harding
Subject Re: More on Too Many Open Files... NetBSD
Date
Msg-id sc1f56c0.021@mail.tpchd.org
Whole thread Raw
In response to More on Too Many Open Files... NetBSD  ("Ian Harding" <ianh@tpchd.org>)
Responses Re: More on Too Many Open Files... NetBSD
Re: More on Too Many Open Files... NetBSD
List 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@tpchd.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@tpchd.org

>>> Bruce Momjian <pgman@candle.pha.pa.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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


pgsql-general by date:

Previous
From: Joe Koenig
Date:
Subject: Re: Way to use count() and LIMIT?
Next
From: "Andrew G. Hammond"
Date:
Subject: Re: Is there a PostgresQL equivalent to the DESCRIBE