| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Chris <dmagick(at)gmail(dot)com> |
| Cc: | Rushabh Doshi <rdoshi(at)vmware(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: db sever seems to be dropping connections |
| Date: | 2006-03-20 22:15:54 |
| Message-ID: | 8269.1142892954@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Chris <dmagick(at)gmail(dot)com> writes:
> Rushabh Doshi wrote:
>> I'm facing an issue with PostgreSQL .. The server seems to drop the
>> connection to my script after a couple of hours (sometimes, not always).
> Sounds more like a network issue.
Yeah --- in particular, it sounds like a connection timeout imposed by
a router or firewall. A lot of NAT-capable routers will drop idle TCP
connections after a certain period of inactivity (typically an hour or
so ... if you're lucky, the router will let you adjust the timeout).
There is no connection timeout built into Postgres itself, so you should
be looking for network-related limitations.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-20 22:20:12 | Re: ambuild parameters |
| Previous Message | Sigurdur Gunnlaugsson | 2006-03-20 21:44:35 | Re: How I can get the real data type result instead of |