Postmaster 7.1.2 hanging

Justin Clift <aa2@bigpond.net.au>

From: Justin Clift <aa2@bigpond.net.au>
To: pgsql-bugs@postgresql.org
Date: 2001-07-06T04:42:21Z
Lists: pgsql-bugs
Hi all,

Running Mandrake 7.2, personally compiled version of PostgreSQL 7.1.2.

Just did a :

pg_ctl stop -m fast

And the postmaster process won't die.

Waited for about 2 minutes, then sent a normal everyday kill signal to the 
postmaster process from the root user (just in case).  Haven't done a kill 9.

The last part of the postgresql log is :

pq_recvbuf: unexpected EOF on client connection
ERROR:  <unnamed> referential integrity violation - key referenced from 
goods_bought not found in goods
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
Fast Shutdown request at Fri Jul  6 14:33:57 2001
Aborting any active transaction...
FATAL 1:  This connection has been terminated by the administrator.

I shutdown the Tomcat process before doing any of this, so I'm thinking 
that's the cause of the unexpected EOF's just before this.

When using "ps -ef" I get this listing of the PostgreSQL processes :

postgres 16067     1  0 Jul04 ?        00:00:07 
/opt/postgresql/bin/postmaster -D /opt/postgresql/data -d 0 -i  

So, any ideas what's jamming the database on?

This isn't urgent, it's a development database I have plenty of recent 
backups of, more to let people know it's happening.

Regards and best wishes,

Justin Clift