Re: pg_ctl: server does not shut down

From: "Gnanakumar" <gnanam(at)zoniac(dot)com>
To: "'Greg Smith'" <greg(at)2ndquadrant(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_ctl: server does not shut down
Date: 2010-10-26 05:32:06
Message-ID: 002701cb74cf$23607f50$6a217df0$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lukasz Brodziak 2010-10-26 06:58:24 Re: Creating role using batch file in windows
Previous Message Tom Lane 2010-10-25 19:57:10 Re: autovacuum launcher process eating up 17G+ of ram?

Browse pgsql-hackers by date

  From Date Subject
Next Message Dean Rasheed 2010-10-26 07:02:22 Re: add label to enum syntax
Previous Message Itagaki Takahiro 2010-10-26 03:21:32 Re: Extensible executor nodes for preparation of SQL/MED