Re: SHMMAX problem - how much is needed?

Steve Holdoway wrote:
> On Tue, 13 Nov 2007 21:00:02 +0100
> Laszlo Nagy <gandalf@shopzeus.com> 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