|
Home > Archive > PostgreSQL Discussion > August 2005 > SOCKET Conection on Windwos 2003 vs PostgreSQL 8.0.1
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SOCKET Conection on Windwos 2003 vs PostgreSQL 8.0.1
|
|
| Julio Cesar 2005-08-25, 11:23 am |
| 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.
Maybe iīm doing something wrong, but with UNIX Serverīs i dont have this situation.
If anyone have a idea, please return ... I use PostgreSQL for the last 4 yearīs and i have to admit that is simply the best choice. Workīs fine and is very, very stable! ! !
Regardīs,
Julio Cesar Ledo Amaral Filho
| |
| Magnus Hagander 2005-08-25, 11:23 am |
| > 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@postgresql
.org so that your
message can get through to the mailing list cleanly
|
|
|
|
|