Re: Help me stop postgres from crashing.

On Apr 24, 4:13 pm, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> Sam <s(dot)(dot)(dot)(at)palo-verde(dot)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(dot)(dot)(dot)(at)postgresql(dot)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.