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