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
