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

From Alvaro Herrera
Subject Re: "Out of memory" errors..
Date
Msg-id 20070813163843.GD4315@alvh.no-ip.org
Whole thread Raw
In response to Re: "Out of memory" errors..  ("Lim Berger" <straightfwd007@gmail.com>)
Responses Re: "Out of memory" errors..  ("Lim Berger" <straightfwd007@gmail.com>)
List pgsql-general
Lim Berger escribió:

> Thanks. I did "su postgres" and ran the ulimit command again. All
> values are the same, except for "open files" which is double in the
> case of this user (instead of 4096, it is 8192). Not sure what I can
> gather from that?

Try "su - postgres" instead (which will run the user start scripts and
may modify the ulimits for that user), but note that the ulimit can also
be changed in the script that starts the Postgres process on system
boot.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: novnov
Date:
Subject: Running a stored procedure via pgagent, need an example
Next
From: "Pavel Stehule"
Date:
Subject: Re: Persistent connections in PHP