| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Fernando Xavier" <fernandoxavier(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Connection idle broken |
| Date: | 2007-11-27 15:09:15 |
| Message-ID: | dcc563d10711270709x7b31b42fs8efa4c8fbc034969@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Nov 27, 2007 8:33 AM, Fernando Xavier <fernandoxavier(at)yahoo(dot)com> wrote:
> Hi,
>
> I have trouble with my java application. Since i change the network configuration, the postgresql idle connections broken after 10 minutes. (i set authentication_timeout = 600 in postgresql.conf).
>
> My network:
>
> 192.168.1.1 (postgresql server and gateway server)
> 192.168.0.1 (linksys wireless router)
> 192.168.0.x (clients)
>
> How i make my idle connections alive for long time?
You can try lowering your tcp_keepalive settings.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Chille | 2007-11-27 15:16:25 | Re: autovacuum process blocks without reporting a deadlock |
| Previous Message | Alvaro Herrera | 2007-11-27 15:07:15 | Re: autovacuum process blocks without reporting a deadlock |