Re: How to "ping" the database

Поиск
Список
Период
Сортировка
От Bill Moseley
Тема Re: How to "ping" the database
Дата
Msg-id 20050817203259.GA7702@hank.org
обсуждение исходный текст
Ответ на How to "ping" the database  (Bill Moseley <moseley@hank.org>)
Список 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 по дате отправления:

Предыдущее
От: Mario Guenterberg
Дата:
Сообщение: Re: postgres 8.x on debian
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL 8.0.3 limiting max_connections to 64 ?