"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.
regards, tom lane