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

From Sander Steffann
Subject Re: "Out of memory" errors..
Date
Msg-id 56DC92C30D27410BA2E4454C34C378DA@sanderthuis
Whole thread Raw
In response to "Out of memory" errors..  ("Lim Berger" <straightfwd007@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: "Lim Berger"
Date:
Subject: Re: "Out of memory" errors..
Next
From: Ben
Date:
Subject: Re: is there a psql equivilent of fsck?