On 8/14/07, Sander Steffann <s.steffann@xxxxxxxxxxx> wrote:
> 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.
Thanks. I see these two lines in that file:
postgres soft nofile 8192
postgres hard nofile 8192
How should I change these values? I am not sure how this reflects the
"ulimit" options.
Thanks!
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
