postmaster stop hangs - Mailing list pgsql-admin

From Simpson
Subject postmaster stop hangs
Date
Msg-id NFBBKOADOLGDLPMAAHMDAEKEDCAA.asimpson@i-55.com
Whole thread Raw
Responses Re: postmaster stop hangs
List pgsql-admin
Greetings,

Running /etc/init.d/postgresql stop results in:

    Stopping postgresql service:               [FAILED]

I ran an strace on "/usr/local/pgsql/bin/pg_ctl stop -D
/data/pgsql/data -s -m fast" and it is sending a SIGINT to processid 5676

Here is a ps of the currently running instance:

postgres  5671     1  0 02:32 pts/0    00:00:00
/usr/local/pgsql/bin/postmaster -D /data/pgsql/data
postgres  5674  5671  0 02:32 pts/0    00:00:00 postgres: writer process
postgres  5675  5671  0 02:32 pts/0    00:00:00 postgres: stats buffer
process
postgres  5676  5675  0 02:32 pts/0    00:00:00 postgres: stats collector
process

In this case, shouldn't it be sending a SIGTERM to 5671?

If I manually send a SIGINT or a SIGTERM to the postmaster (5671 in this
case), postgres obediently shuts down.

5676 is in the */data/postmaster.pid

Thanks for any help,
Drew.

postgresql 8.0.2
Linux xxx 2.6.9-5.0.3.EL #1 Sat Feb 19 18:26:49 CST 2005 i686 i686 i386
GNU/Linux



pgsql-admin by date:

Previous
From: Alan Donald
Date:
Subject: Database Corruption, Tables, Databases missing
Next
From: Michael Fuhr
Date:
Subject: Re: Database Corruption, Tables, Databases missing