Dear all,

Environement:
- OS : Ubuntu 10.04 LTS.
- DB:  postgresql 8.4.
- Connection to postgresql using sslmode = disable

Scenario :

1.       I use pgadmin to connect/disconnect to the postgresql server on port 
5432 or

2.       I use a progam using libpq  and make PQconnectdb and PQfinish.

Bug:

In both cases, the client socket (pgadmin or my program) remains in TIME_WAIT 
state.
I have used wireshark to sniff the TCP protocol.

We have at the end of a connection:

Client                  Server
   --->    FIN,ACK  --->
   <---    FIN,ACK  <---
   --->      ACK    --->

This ends up in a TIME_WAIT state. The TCP protocol should be

Client                  Server
   --->    FIN,ACK  --->
   <---      ACK    <---
   <---    FIN,ACK  <---
   --->      ACK    --->

I suppose there is a bug in the postgresql server that do not send an ack to 
the client.

Could you please clarify this situation ? I am a bit lost.

Thank you,

Franck Lefort


Reply via email to