Re: BUG #2642: Connection problems without IPv6

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