Re: BUG #6179: "service postgresql-9.0 stop" does not stop postgresql server

Hi,

I have already fixed it in SVN:

http://svn.pgrpms.org/browser/rpm/redhat/9.0/postgresql/EL-5/postgresql.init

You can either use this version, or wait for the updated packages (which
will appear soon)

Regards, Devrim

On Fri, 2011-08-26 at 08:31 +0000, Ken wrote:
> The following bug has been logged online:
>
> Bug reference: 6179
> Logged by: Ken
> Email address: borg(at)sprint-v(dot)com(dot)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(at)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(at)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" ]
> ----------------------------------------------------------------------------
> -----------------------
>

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz