Reply-To: <gnanam@zoniac.com>
From: "Gnanakumar" <gnanam@zoniac.com>
To: "'Greg Smith'" <greg@2ndquadrant.com>
Cc: <pgsql-admin@postgresql.org>
References: <001201cb0321$df429d40$9dc7d7c0$@com>
	<00ca01cb03dc$a9ffe780$fdffb680$@com>
	<002d01cb7417$595f78d0$0c1e6a70$@com>
	<4CC5A0C6.8080901@2ndquadrant.com>
In-Reply-To: <4CC5A0C6.8080901@2ndquadrant.com>
Subject: Re: pg_ctl: server does not shut down
Date: Tue, 26 Oct 2010 11:02:06 +0530
Organization: Zoniac Software Private Limited
Message-ID: <002701cb74cf$23607f50$6a217df0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: Act0WHzNciMz3UapRaiOosVWz/QYHQAc+Plg
Content-Language: en-us

> You can check if PITR is disabled by executing:
> SHOW archive_command;
> At a psql prompt.  If that's empty, then you turned it off, and it isn't
involved in the shutdown issue you have anymore.

Yes, I could see empty value here.

> Take a look at what processes are still running against the database and
see if there are clients attached after the fast shutdown attempt.  
> If so, those are your problem, not something to PITR.

Yes, I can see the following processes still running. I used the command 'ps
-ef |grep postgres' to list.
postgres  3376     1  0 07:20 ?        00:00:00
/mnt/database/pgsql/bin/postgres -D /usr/local/pgsql/data
postgres  3381  3376  0 07:20 ?        00:00:00 postgres: logger process

postgres  3383  3376  0 07:20 ?        00:00:00 postgres: writer process


But why logger and writer process are still running/showing up here for a
very long time after issuing 'service postgresql stop'.  What could be the
problem?  Also, am sure here that no other clients (database connections)
are connected at this time.