Re: Why doesn't src/backend/port/win32/socket.c implement bind()?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Why doesn't src/backend/port/win32/socket.c implement bind()?
Date: 2016-04-25 15:14:14
Message-ID: 32217.1461597254@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
> Michael Paquier <michael(dot)paquier(at)gmail(dot)com> writes:
>> Not worse, and still not enough... bowerbird complained again:
>> http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=bowerbird&dt=2016-04-25%2002%3A13%3A54

> That's a different symptom that seems unrelated:

> cannot remove directory for C:\prog\bf\root\HEAD\pgsql.build\src\bin\scripts\tmp_check\data_main_21Nw\pgdata\global: Directory not empty at C:/Perl64/lib/File/Temp.pm line 902.

Ah, scratch that, I was taking that as being the cause of the reported
failure but it's just noise, cf <31417(dot)1461595864(at)sss(dot)pgh(dot)pa(dot)us>.

You're right, we're still getting

# pg_ctl failed; logfile:
LOG: could not bind IPv4 socket: Permission denied
HINT: Is another postmaster already running on port 60208? If not, wait a few seconds and retry.
WARNING: could not create listen socket for "127.0.0.1"
FATAL: could not create any TCP/IP sockets
LOG: database system is shut down
Bail out! pg_ctl failed

So the connect() test is inadequate. Let's try bind() with SO_REUSEADDR
and see whether that makes things better or worse.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2016-04-25 15:27:24 Re: Rename max_parallel_degree?
Previous Message Tom Lane 2016-04-25 14:51:04 Bogus cleanup code in PostgresNode.pm