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

Re: Enabling connection pooling by default

From: "Adam M" <gnuman1(at)gmail(dot)com>
To:
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Enabling connection pooling by default
Date: 2008-10-17 02:23:14
Message-ID: 84b37b360810161923o55bb14a0p96e6e7c9c43241e5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
On Wed, Oct 15, 2008 at 2:47 PM, Andrus <kobruleht2(at)hot(dot)ee> wrote:
>> Aren't pulled connections going to suffer from the same disconnection
>> problems as nonpulled connections?
>
> No.
> Only idle connections seems to be killed automatically by ADSL modem.
> Maybe TCP_KEEPALIVE can fix this but I havent found any inforamtion about
> its usage with PostgreSQL.

If your ADSL modem is also your router, and you are using NAT, then it
is not killing your connection. It is merely removing it from active
connection queue after 3 min or so of no activity.

If your ADSL modem is not a router, and "disconnects" your connection,
then the ADSL modem is broken. If you have a NAT outside the modem,
then it is the NAT that is timing out, not the modem.

TCP_KEEPALIVE messages are only useful when you have a non-public IP
and/or using NAT and/or want PostgreSQL to close connections where the
client has disappeared.

- Adam

In response to

Responses

pgsql-odbc by date

Next:From: salman SheikhDate: 2008-10-20 09:34:28
Subject: Error in Adding All Table
Previous:From: AndrusDate: 2008-10-16 08:56:52
Subject: Re: Enabling connection pooling by default

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