Magnus Hagander wrote: >> The following bug has been logged online: >> ... >> When I start the PostgreSQL service, and I have my LAN >> network interface activated with TCP/IP installed, but IPv6 >> deinstalled, I cannot connect to the PostgreSQL database. In >> the log file, I get the following error >> message: >> >> "LOG: could not receive data from client: An operation was >> attempted on something that is not a socket." >> >> ... >> It happens only if: >> >> - the LAN network interface is activated and >> - the TCP/IP protocol is activated and >> - the TCP/IP v6 protocol is not installed > > I've never seen any mention at all about this before. Do you have any > antivirus or firewall software on this machine? Especially firewall > software has a bad habit of breaking regular winsock operations, as > we've seen in many different cases... > > Also, what is the value of listen_addresses in your postgresql.conf?
No, there is no special software except the Win XP firewall, but it happens even if it switched off. I had all other services and software deactivated, it happened anyway. It tried various values for listen_address including 'localhost' and '127.0.0.1.', but it did not matter. It also happens when listen_address is not set at all (which defaults to localhost I guess). That means if you simply install PostgreSQL on Windows XP under the above conditions (LAN interface active, TCP/IP active, TCP/IP 6 not installed), then in the last phase of the installation where the installer tries to connect to the database to install some extensions, it fails already.
netstat -anb shows: TCP 127.0.0.1:5432 0.0.0.0:0 LISTEN [postmaster.exe] Is here anybody with Win XP who can confirm that behavior? -- Christoph ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org