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

Re: Connection of postgres

From: "Nguyen, Lam Thuy" <l7nguyen(at)fcg(dot)com>
To: "Adam M" <gnuman1(at)gmail(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Connection of postgres
Date: 2008-04-09 18:57:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
i open connection, and leave it for few hour, and then excute query, and get error.


From: pgsql-odbc-owner(at)postgresql(dot)org on behalf of Adam M
Sent: Wed 4/9/2008 2:40 PM
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Connection of postgres

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?

Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
To make changes to your subscription:

This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient.  Any review, reliance, or distribution by others or forwarding without express permission is strictly prohibited.  If you are not the intended recipient, please contact the sender and delete all copies.

In response to

pgsql-odbc by date

Next:From: noreplyDate: 2008-04-15 13:02:57
Subject: [ psqlodbc-Bugs-1010376 ] GUID code missing in convert.c ("Unrecognized C_parameter ..") and fix
Previous:From: Adam MDate: 2008-04-09 18:40:28
Subject: Re: Connection of postgres

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