Too many open files... - Mailing list pgsql-general

Well, we got a problem with postgres 6.5.2 on SOlaris 2.6, when:

1) Executing a query with a trigger behind it, making quite a big amount
of
   queries on different relations,
2) and when this query is executed from an applet via a servlet on
Apache 1.3.3
   using postgresql.jar as db driver.

So, the message is:

ERROR:  Load of file /usr/dblocal/pgsql/lib/plpgsql.so failed: ld.so.1:
/usr/dblocal/pgsql/bin/postmaster: fatal: /dev/zero: open failed: Too
many open files

(or similar).

The problem does not exist, if we execute it via psql.

So I tracked it down to dlopen(filename,1). But really, I do not know,
what might
be the real reason for the failure: is it postgres (probably not),
Apache, restricting
the environment "somehow", or postgresql.jar (it should just give the
query to the
backend, so probably not as well), or Solaris itself (but why do I not
get an error,
if I execute it via psql?) or where should I check further?

I am a little confused on how to repair the problem, as it is most
probably not
a problem with postgres. Anybody had similar experiences or even a
solution (besides
not using the trigger)?

Thanks,
Thomas Mack
TU Braunschweig, Abt. Informationssysteme