Re: API like mysql_ping

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: Sivakumar K <sivakumark(at)pervasive-postgres(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: API like mysql_ping
Date: 2005-08-25 15:38:55
Message-ID: 29352.1124984335@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Oliver Jowett <oliver(at)opencloud(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Oliver Elphick 2005-08-25 17:21:25 Re: TODO list comments
Previous Message Tom Lane 2005-08-25 15:34:36 Re: Win32 Thread safetyness