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

Поиск
Список
Период
Сортировка
От Chris Angelico
Тема Re: How to check for server availability? [v9.3.1, Linux]
Дата
Msg-id CAPTjJmrv3uTvmFYVnRAoBkkG859KKLJP2trbtzE+g1UPfnf9Pw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to check for server availability? [v9.3.1, Linux]  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Ответы Re: How to check for server availability? [v9.3.1, Linux]  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
On Sat, May 19, 2012 at 12:09 AM, Vincenzo Romano
<vincenzo.romano@notorand.it> wrote:
> You said enough about PQstatus. So issuing a "blank" command seems to
> be a good idea. Possibly the only one.
>
> Well, a "ping" function trying to use the current "PGconn*" to ping
> the server would make a lot of sense, though.

If it helps make your code clearer, you could send the query "/* ping
*/", which would be parsed by the server as a comment. I've not
verified, but a recent thread here mentioned that /**/ comments
(unlike double-hyphen ones) get sent to the server, so you'll see it
in your logs.

ChrisA

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

Предыдущее
От: Vincenzo Romano
Дата:
Сообщение: Re: How to check for server availability? [v9.3.1, Linux]
Следующее
От: leaf_yxj
Дата:
Сообщение: Re: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks.