Steve Holdoway wrote:
On Tue, 13 Nov 2007 21:00:02 +0100
Laszlo Nagy <gandalf@xxxxxxxxxxxx> wrote:
[snip]
What are postgres's ulimits???
Output of "cat /etc/login.conf" (part of it):
default:\
:passwd_format=md5:\
:copyright=/etc/COPYRIGHT:\
:welcome=/etc/motd:\
:setenv=MAIL=/var/mail/$,BLOCKSIZE=K,FTP_PASSIVE_MODE=YES:\
:path=/sbin /bin /usr/sbin /usr/bin /usr/games /usr/local/sbin
/usr/local/bin /usr/X11R6/bin ~/bin:\
:nologin=/var/run/nologin:\
:cputime=unlimited:\
:datasize=unlimited:\
:stacksize=unlimited:\
:memorylocked=unlimited:\
:memoryuse=unlimited:\
:filesize=unlimited:\
:coredumpsize=unlimited:\
:openfiles=unlimited:\
:maxproc=unlimited:\
:sbsize=unlimited:\
:vmemoryuse=unlimited:\
:priority=0:\
:ignoretime@:\
:umask=022:
The login class of the user "pgsql" is not given, so it must be the default.
Regards,
Laszlo
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
