Thread: BUG #6179: "service postgresql-9.0 stop" does not stop postgresql server
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" ] ---------------------------------------------------------------------------- -----------------------
Re: BUG #6179: "service postgresql-9.0 stop" does not stop postgresql server
From
Devrim GÜNDÜZ
Date:
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