Re: "Out of memory" errors.. - Mailing list pgsql-general

From Lim Berger
Subject Re: "Out of memory" errors..
Date
Msg-id 69d2538f0708131116y6b9740cem58ce9a3399346aa3@mail.gmail.com
Whole thread Raw
In response to "Out of memory" errors..  ("Lim Berger" <straightfwd007@gmail.com>)
List pgsql-general
On 8/14/07, Sander Steffann <s.steffann@computel.nl> wrote:
> 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.


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!

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: is there a psql equivilent of fsck?
Next
From: "Sander Steffann"
Date:
Subject: Re: "Out of memory" errors..