> Hi All,
>
> I'm tuning up my database and need to increase the max_stack_depth
> parameter in postgresql.conf.
>
> I've edited the /etc/security/limits.conf and added
> * soft stack 12288
> * hard stack 12288
>
> but I noticed the comments at the top of the file -
> #This file sets the resource limits for the users logged in via PAM.
> #It does not affect resource limits of the system services.
>
> After saving my changes and rebooting postgresql will not start, I know
> that the configuration change I have made will only affect users
> authenticated by PAM but I need to amend the stack depth for ALL system
> processes.
>
> Can anybody point me in the right direction?
>
> I'm also asking on the CentOS mailing list but have been pointed to the
> file above which is not the setting I require.
>
> while logged in I can run ulimit -s 12288 but this only affects the
> current shell.
Hi,
on a CentOS 6.7 box I can confirm that adding those lines to
/etc/security/limits.conf DOES increase the limit to 12288
(after a reboot).
I don't see the PAM line, though. What version of CentOS are
you using?
Bye,
Chris.