Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 9 Apr 2008 13:40:28 -0500
- Message-id: <84b37b360804091140r58018ccrdf7212f3662a7d1e(at)mail(dot)gmail(dot)com>
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?
- Follow-Ups:
- Re: Connection of postgres
- From: Nguyen, Lam Thuy
- Re: Connection of postgres
- References:
- get number of rows selected
- From: Malm Paul
- Connection of postgres
- From: Nguyen, Lam Thuy
- Re: Connection of postgres
- From: Andrei Kovalevski
- Re: Connection of postgres
- From: Nguyen, Lam Thuy
- Re: Connection of postgres
- From: Andrei Kovalevski
- Re: Connection of postgres
- From: Nguyen, Lam Thuy
- Re: Connection of postgres
- From: Raymond O'Donnell
- Re: Connection of postgres
- From: Nguyen, Lam Thuy
- get number of rows selected
- Prev by Date: [ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0
- Next by Date: Re: Connection of postgres
- Previous by thread: Re: Connection of postgres
- Next by thread: Re: Connection of postgres
- Indexes: