Re: More on Too Many Open Files... NetBSD

Hi,

from /usr/local/share/doc/postgresql/README.OpenBSD
on my OpenBSD 2.9 box

-snip
The ulimit settings can also be a problem.  The following can be
added for the postgresql user in the /etc/login.conf file:

        postgresql:\
                :maxproc-max=256:\
                :maxproc-cur=256:\
                :openfiles-cur=768:\
                :datasize-max=256M:\
                :datasize-cur=64M:\
                :stacksize-cur=4M:

For more than about 250 connections, these numbers should be
increased. Please report any changes and experiences to the package
maintainers so that we can update this file for future versions.
-/snip

you can assign a user to a login class by entering into the 5th field of your
passwd file. (edit it with vipw) check passwd(5) to be sure

postgresql:*:1013:1013:postgresql:0:0:PostgreSQL:/var/postgresql:/sbin/nologin

--
Matt Sauve-Frankel        Philosophie Bleue | http://philosophiebleue.com
Network Administrator                  | http://pblue.com
--  An idea is not responsible for the people who believe in it