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