> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
