The following bug has been logged online: Bug reference: 3808 Logged by: Daniel Migowski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows Server 2003 Description: Connections stays open in state CLOSE_WAIT Details:
Hello dear bug report readers, I am using PostgreSQL 8.1.4 on Windows 2003 Server and do my backups with the pg_dump in the same package. >From time to time the server side of the connection remains open with netstat showing the connection in state CLOSE_WAIT. The pg_dump process at this time has succesfully done its job and is gone long, but the connection stays open. I notices this, because, together with the connection, many AccessShare locks on different tables and one ExclusiveLock remains open. It is possible to cancel the backend process from PGAdmin, but after grinding the server to a halt with the most minor update script (it was a DROP NOT NULL), I really get annoyed about this bug. Even more problematic is, that the behaviour cannot be reproduced (i tried for hours), it just occurs occacionally. I noticed the changelog of version 8.1.10 (Magnus: Windows Socket Improvements). Will they fix this bug? Do you need more information to fix this bug? Thank you very much for taking your time to cover this in advance, and with best regards, Daniel Migowski ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
