Re: Postmaster crashes

"Mark Alliban" <MarkA@idnltd.com> writes:
> pq_recvbuf: unexpected EOF on client connection
> Server process (pid 2087) exited with status 139 at Tue Feb 13 15:38:08 2001
> Terminating any active server processes...
> Server processes were terminated at Tue Feb 13 15:38:08 2001
> Reinitializing shared memory and semaphores

> The first line appears many times (once every few minutes) but doesn't cause
> a problem. However the server then exits and the database is down.

The unexpected-EOF messages are probably unrelated to the crash.  What
Postgres version are you running?  There should be a corefile left from
the crashed backend --- can you get a stack trace from it?  How about
running the postmaster with -d2 to log queries, so that you can see what
queries were being executed at the time of the crash?

            regards, tom lane