| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Lim Berger <straightfwd007(at)gmail(dot)com> |
| Cc: | Bill Moran <wmoran(at)potentialtech(dot)com>, Postgresql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: "Out of memory" errors.. |
| Date: | 2007-08-13 16:38:43 |
| Message-ID: | 20070813163843.GD4315@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2007-08-13 16:46:50 | Re: Persistent connections in PHP |
| Previous Message | novnov | 2007-08-13 16:36:12 | Running a stored procedure via pgagent, need an example |