Skip site navigation (1) Skip section navigation (2)

Re: Connection of postgres

From: "Adam M" <gnuman1(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Connection of postgres
Date: 2008-04-09 18:40:28
Message-ID: (view raw, whole thread or download thread mbox)
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

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


pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group