Thread: backend terminated abnormally

Hello everyone:

I have a server running RedHat 7.1, Kern 2.4.21 and glibc ver 2.2.5.  I
have had a postgresql database on it for two years now without any
problems.  When I run vacuum verbose analyze it crashes and leaves me
with the error:

NOTICE : analyzing pg_type server closed connection unexpectedly.
    This probably means the backend terminated abnormally before or
while processing the request.

I've looked this up on the lists and found little that I think pertains
to me.

According to the lists my glibc library is past the version needed.  My
kernel is also up to par.

What are my options here?  I don't think I have a version problem but I
did see a post about adjusting the shared_buffers.  It doesn't make
sense to me to change this since I didn't get a memory error.

Vacuum has been working religiously for the past two years.  Oh yeah, my
version of postgres is 7.2.

I did notice that "vacuum verbose users" works but "vacuum verbose
analyze" doesn't.

HELP!  Thanks.

"Bob Powell" <bob@hotchkiss.org> writes:
> NOTICE : analyzing pg_type server closed connection unexpectedly.
>     This probably means the backend terminated abnormally before or
> while processing the request.

Not good ... can you get a stack trace from the backend core dump?

> Vacuum has been working religiously for the past two years.  Oh yeah, my
> version of postgres is 7.2.

Please tell us it's 7.2.4.  Or if it isn't, make it so.

            regards, tom lane