The following bug has been logged online:
Bug reference: 6179
Logged by: Ken
Email address: borg@sprint-v.com.ru
PostgreSQL version: 9.0.4
Operating system: CentOS 6.0 x86_64
Description: "service postgresql-9.0 stop" does not stop postgresql
server
Details:
Hi.
I am use RPM binaries from postgresql.org yum repository. Postgresql started
normally ("service postgresql-9.0 start"), but refuse stopping ("service
postgresql-9.0 stop"):
---------------------------------------------
[root@storage-2 init.d]# service postgresql-9.0 stop ; echo ; sleep 3 ; ps
ax | fgrep post
Stopping postgresql-9.0 service: Postmaster dead, but subsys exists.
[ OK ]
1685 ? Ss 0:00 /usr/libexec/postfix/master
22254 ? S 0:00 /usr/pgsql-9.0/bin/postmaster -p 5432 -D
/var/lib/pgsql/9.0/data
22262 ? Ss 0:00 postgres: logger process
22264 ? Ss 0:00 postgres: writer process
22265 ? Ss 0:00 postgres: wal writer process
22266 ? Ss 0:00 postgres: autovacuum launcher process
22267 ? Ss 0:00 postgres: stats collector process
22344 pts/2 S+ 0:00 fgrep post
[root@storage-2 init.d]#
---------------------------------------------
Here proposed patch for /etc/rc.d/init.d/postgresql-9.0 (seems typo, as
lockfile in almost cases have zero size):
----------------------------------------------------------------------------
-----------------------
158c158
< if [ -e "$lockfile" ] && [ ! -s "$lockfile" ]
---
> if [ -e "$lockfile" ] && [ ! -s "$pidfile" ]
----------------------------------------------------------------------------
-----------------------