Re: Connection of postgres - Mailing list pgsql-odbc

From Adam M
Subject Re: Connection of postgres
Date
Msg-id 84b37b360804091140r58018ccrdf7212f3662a7d1e@mail.gmail.com
Whole thread Raw
In response to Re: Connection of postgres  ("Nguyen, Lam Thuy" <l7nguyen@fcg.com>)
List 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?

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0
Next
From: "Nguyen, Lam Thuy"
Date:
Subject: Re: Connection of postgres