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
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 |