how to test whether postgres server is running?

Поиск
Список
Период
Сортировка
От Reynard Hilman
Тема how to test whether postgres server is running?
Дата
Msg-id 3E837F5A.5050401@lightsky.com
обсуждение исходный текст
Ответ на Re: Bug in contrib/intagg int_array_enum() ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: how to test whether postgres server is running?  (Darren Ferguson <darren@thread.crystalballinc.com>)
Список pgsql-general
Hi everyone,

I run into problem where pg_pconnect (in php script) failed to get
connection to the postgres server even when the server is actually
running because the server is too busy (serving too many requests).

So I want to check from php script if postgres server is running. The
only way I could think of to is telnet the server on port 5432 (where
postgres is listening).

Does someone know a better way to check if postgres server is running?

thanks
- reynard


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

Предыдущее
От: "Andrew Bartley"
Дата:
Сообщение: Re: About OIDs
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Bug in contrib/intagg int_array_enum() ?