Re: Connection of postgres

From: "Adam M" <gnuman1(at)gmail(dot)com>
To:
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Connection of postgres
Date: 2008-04-09 18:40:28
Message-ID: 84b37b360804091140r58018ccrdf7212f3662a7d1e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I've had a similar "problem". The connection times out and get closed
after a few hours. The solution was to do a query to keep the database
alive, for example "SELECT 1" and that's all. That is done every few
minutes.

The real test is to open 250 connections, and issue queries on each
without idle time. Does connection drop occur on active connections?

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Nguyen, Lam Thuy 2008-04-09 18:57:41 Re: Connection of postgres
Previous Message noreply 2008-04-07 19:10:36 [ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0