| From: | Matt Sauve-Frankel <baud(at)philosophiebleue(dot)com> |
|---|---|
| To: | Ian Harding <ianh(at)tpchd(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: More on Too Many Open Files... NetBSD |
| Date: | 2001-12-20 00:28:00 |
| Message-ID: | 20011219192800.B31917@hiss.philosophiebleue.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Reyes | 2001-12-20 00:37:54 | Re: copy vs. insert w/ no autocommit |
| Previous Message | Matt Sauve-Frankel | 2001-12-20 00:05:19 | Re: More on Too Many Open Files... NetBSD |