Re: need a method to ping a running database

Поиск
Список
Период
Сортировка
От Jay O'Connor
Тема Re: need a method to ping a running database
Дата
Msg-id 3.0.1.32.20030611180749.008784f0@cybermesa.com
обсуждение исходный текст
Ответ на need a method to ping a running database  (Travis Hume <travis.hume@tenzing.com>)
Ответы Re: need a method to ping a running database  (Travis Hume <travis.hume@tenzing.com>)
Список pgsql-general
> It seems that if you start postgresql and then issue a "kill -9" on the
postmaster processes a .pid file is left
>behind (understandable), but then if you run "pg_ctl status" it will
>immediately report that the database is running and give you the pid
>number and whatever else.  This is a bit misleading to say the least.

First thoght is don't do "kill -9" other than the pid problem is the probem
that postgresql caches data in memory and that could be a problem if you
kill like that.  Use pg_ctl stop -m fast or pg_ctl stop -m immediate

Take care,
Jay

В списке pgsql-general по дате отправления:

Предыдущее
От: Edmund Dengler
Дата:
Сообщение: Performance of a query
Следующее
От: Travis Hume
Дата:
Сообщение: Re: need a method to ping a running database