Hi Lim,
> "Lim Berger" <straightfwd007@gmail.com> writes:
>> Wow, you are right! The "su - postgres" showed up with wildly
>> different values! Most notably, the "max user processes" is only 20!!
>> Whereas in the regular user stuff it was above 14000. Would you know
>> how to change this in a CentOS Linux machine? Where can I find the
>> startup settings for postgresql?
>
> Yipes, that's pretty bogus. The most likely culprit would be a .profile
> or .bashrc script belonging to the postgres user --- poke around in its
> home directory.
It might also be in /etc/security/limits.conf.
Good luck,
Sander