| From: | "Sander Steffann" <s(dot)steffann(at)computel(dot)nl> |
|---|---|
| To: | "Lim Berger" <straightfwd007(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Postgresql General List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: "Out of memory" errors.. |
| Date: | 2007-08-13 18:10:38 |
| Message-ID: | 56DC92C30D27410BA2E4454C34C378DA@sanderthuis |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Lim,
> "Lim Berger" <straightfwd007(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-08-13 18:16:22 | Re: is there a psql equivilent of fsck? |
| Previous Message | Michael Glaesemann | 2007-08-13 18:08:49 | Re: is there a psql equivilent of fsck? |