Re: Postmaster 7.1.2 hanging

I also had this experience in Mandrake 8.0 after the postgresql 7.1.2
installation.
I modified postgresql.conf and stopped the service.
I looked at the initscript and it seem like "/usr/bin/pg_ctl stop -D
$PGDATA -s -m fast"
can't stop  the daemon. Kill -15 did the job.

sherwin

aa2@bigpond.net.au writes:
>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