How to check for server availability? [v9.3.1, Linux]

Поиск
Список
Период
Сортировка
От Vincenzo Romano
Тема How to check for server availability? [v9.3.1, Linux]
Дата
Msg-id CAHjZ2x5dXgi2NYrR_LNt_FwT3M3Zj=2e07xL=5-BcL_KwufmpA@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to check for server availability? [v9.3.1, Linux]
Список pgsql-general
Hi all.
I'd need to check from a C language program whether the server is
running or not.
I was planning to use either "PGPing PQping(const char *conninfo)" or
"ConnStatusType PQstatus(const PGconn *conn)".
I have my program running and checking from time to time whether the
connection is kicking and alive.
In order to test the things I've done the following: while the program
is waiting for input I simply restart the postgresql server.
The issue is thayt both functions return PQPING_OK and CONNECTION_OK
respectively.
When I forward the request, I get an error: "FATAL:  terminating
connection due to administrator command".
How can I reliably check the server status?
TIA:

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

Предыдущее
От: Marti Raudsepp
Дата:
Сообщение: Re: Re: Is EXISTS the most efficient approach for PostgreSql to check for existence of nodes in a tree?
Следующее
От: Piotr Ciechomski
Дата:
Сообщение: 100% cpu usage on some postmaster processes kill the complete database