Re: API like mysql_ping - Mailing list pgsql-hackers

From Tom Lane
Subject Re: API like mysql_ping
Date
Msg-id 29352.1124984335@sss.pgh.pa.us
Whole thread Raw
In response to Re: API like mysql_ping  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-hackers
Oliver Jowett <oliver@opencloud.com> writes:
> Sivakumar K wrote:
>> Do we have an API like mysql_ping to check whether the server is up and
>> running after the connection has been established?

> At the protocol level, you could send Sync and wait for ReadyForQuery.

At the client level, the easiest thing is probably to execute an empty
query string.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Win32 Thread safetyness
Next
From: Oliver Elphick
Date:
Subject: Re: TODO list comments