We have started getting the error
FATAL: terminating connection due to administrator command
in some of our processes. Searching in the archives, I gather that this is caused by a SIGTERM, and might be coming from a ulimit problem.
We are running Solaris 9/Intel, and the ulimit for nofiles for the database owner process is 256. I suspect this needs to be set to "unlimited", which I don't think should cause a problem on Solaris (?).
Is there any rule of thumb for determining how many file descriptors a given postmaster would use, e.g., a way to find out how many data files exist on the server, and/or an estimate for how many of them would have to be open at any given time? Do ALL of the data files get kept open, or do they get opened and closed?
Thanks.
- DAP
----------------------------------------------------------------------------------
David Parker Tazz Networks (401) 709-5130