Re: SOCKET Conection on Windwos 2003 vs PostgreSQL 8.0.1

> Hi,
>
> I´m Julio and a have a situation running W2003 and DBExpress.
>
> I connect to the W2003 with socket (:5432) and, when i save
> the package on my table, a new postgres.exe process start.
> Ok, no problems until here. I disconnect from the W2003 and
> the new proccess just die....
>
> The problem occurs when the cable connection fault between
> the two PC´s after the connection started. The new process
> that have been created on the W2003 (my server) dont die.
> Just stay there. I have to reboot the PostgreSQL 8.0.1 to
> clear the process.

The process should die once the TCP timeout has expired. This is IIRC 2 hours by default, it could be 4. You can chance this, but only on a per-server basis.

This happens when the connectino just goes away and there is no packet telling the server it's closing. There is no way for postgres to know the client went away.

//Magnus