| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Otto Blomqvist" <o(dot)blomqvist(at)secomintl(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgres Disconnection problems |
| Date: | 2005-11-19 03:38:00 |
| Message-ID: | 16832.1132371480@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Otto Blomqvist" <o(dot)blomqvist(at)secomintl(dot)com> writes:
> So far so good. Problem is that the postmaster does not detect this
> connection as dead and keeps it idle for an unknown amount of time. This is
> a real problem for us because we use persistent connections to authorize
> access to a custom built 68030 based system, which has a limited number of
> "slots" that we can use. By not releasing a dead connection we are also
> holding that 68030 slot busy.
PG 8.1 lets you fool with the TCP keepalive timeouts, if you are on a
platform that allows per-connection adjustment of them (which recent
Linuxen do).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2005-11-19 03:52:22 | Re: Upgrading from 8.0 to 8.1 on Debian |
| Previous Message | Bruce Momjian | 2005-11-19 02:54:54 | Re: [ANNOUNCE] Sun supporting PostgreSQL |