Re: Help me stop postgres from crashing.

On Apr 24, 4:13 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Sam <s...@palo-verde.us> writes:
> > A particular web application I am working has a staging version
> > running one a vps, and a production version running on another vps.
> > They both get about the same usage, but the production version keeps
> > crashing and has to be re-started daily for the last couple days.  The
> > log file at the time of crash looks like this:
> > LOG:  could not accept new connection: Cannot allocate memory
> > LOG:  select() failed in postmaster: Cannot allocate memory
>
> This looks like a system-level memory shortage.  You might find useful
> information in the kernel log.  I'd suggest enabling timestamps in the
> PG log (see log_line_prefix) so that you can correlate events in the
> two log files.
>
>                         regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

Thanks, for the responses.

I've enabled the timestamps on the log lines.