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@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" ]
> ----------------------------------------------------------------------------
> -----------------------
>


--
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