Re: How to "ping" the database - Mailing list pgsql-general

From Bill Moseley
Subject Re: How to "ping" the database
Date
Msg-id 20050817203259.GA7702@hank.org
Whole thread Raw
In response to How to "ping" the database  (Bill Moseley <moseley@hank.org>)
List pgsql-general
On Wed, Aug 17, 2005 at 04:25:48PM -0400, Tom Lane wrote:
> Of course, this begs the question of what ping is really supposed to
> test and when it's supposed to be allowable.  The above will not work
> if in the middle of retrieving a query result, for example.

Well, there's that.  I'm not really sure why there's a need for a ping
-- and I've heard others question it, too.

Perl's DBI has a connect_cached() function that is suppose to return a
cached connection if it's still alive.  So that is one place "ping" is
used.  If ping fails then a new connection is created.


--
Bill Moseley
moseley@hank.org


pgsql-general by date:

Previous
From: Mario Guenterberg
Date:
Subject: Re: postgres 8.x on debian
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 8.0.3 limiting max_connections to 64 ?