Re: pg_ctl: server does not shut down
От | Gnanakumar |
---|---|
Тема | Re: pg_ctl: server does not shut down |
Дата | |
Msg-id | 002701cb74cf$23607f50$6a217df0$@com обсуждение исходный текст |
Ответ на | Re: pg_ctl: server does not shut down (Greg Smith <greg@2ndquadrant.com>) |
Ответы |
Re: pg_ctl: server does not shut down
|
Список | pgsql-admin |
> 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.
В списке pgsql-admin по дате отправления: