Обсуждение: API like mysql_ping

PQstatus perhaps?

http://www.postgresql.org/docs/8.0/interactive/libpq-status.html

Chris

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?
> 
>  
> 
> I checked the PostgreSQL docs but of no use.
> 
> Is there any work around for this?
> 
>  
> 
> /*/ Regards, /*/
> 
> /*/ Siva Kumar.K /*/
> 
>  
> 

Christopher Kings-Lynne wrote:
> PQstatus perhaps?
> 
> http://www.postgresql.org/docs/8.0/interactive/libpq-status.html

This only returns the last status, not the current.
pgAdmin uses SELECT 1 for this.

Regards,
Andreas

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.

-O

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


>> PQstatus perhaps?
>>
>> http://www.postgresql.org/docs/8.0/interactive/libpq-status.html

> This only returns the last status, not the current.
> pgAdmin uses SELECT 1 for this.

Better still: PQtransactionStatus, followed by a quick
PQexec of "SELECT 'pingtest' if it returns PQTRANS_IDLE.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200508250940
https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEARECAAYFAkMNymsACgkQvJuQZxSWSsjm2gCgt+4pdyd5GiFjyJeDqNSbR14C
svMAn0OxrtEqcFgDruogLdmhvavokdSb
=nist
-----END PGP SIGNATURE-----

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