Hi Lim,
"Lim Berger" <straightfwd007@xxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings