Fwd: Problem with Unix sockets when porting MobilityDB for Windows

From: Esteban Zimanyi <esteban(dot)zimanyi(at)ulb(dot)be>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Fwd: Problem with Unix sockets when porting MobilityDB for Windows
Date: 2021-09-05 12:38:18
Message-ID: CAPqRbE7LHC3kyvqqGnWdEtMFgEOpbzbeR0_F6OVwXFRKuAEBag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Windows 10 supports Unix sockets as reported, e.g., here
https://devblogs.microsoft.com/commandline/af_unix-comes-to-windows/

We run the tests on MobilityDB using an ephemeral instance that is created
by the test suite and torn down afterwards.
https://github.com/MobilityDB/MobilityDB/blob/develop/test/scripts/test.sh
For this we use Unix sockets and thus the pg_ctl command is configured as
follows

PGCTL="${BIN_DIR}/pg_ctl -w -D ${DBDIR} -l ${WORKDIR}/log/postgres.log -o
-k -o ${WORKDIR}/lock -o -h -o ''"

The log file reports things are working as expected

2021-09-05 14:10:53.366 CEST [32170] LOG: starting PostgreSQL 13.3 on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0,
64-bit
2021-09-05 14:10:53.372 CEST [32170] LOG: listening on Unix socket
"/home/esteban/src/MobilityDB/build/tmptest/lock/.s.PGSQL.5432"
2021-09-05 14:10:53.394 CEST [32171] LOG: database system was shut down at
2021-09-05 14:10:52 CEST
2021-09-05 14:10:53.412 CEST [32170] LOG: database system is ready to
accept connections

We are trying to port MobilityDB on Windows using msys2. In this case the
above command does not work as reported in the corresponding log

2021-09-05 14:34:10.553 CEST [19060] LOG: starting PostgreSQL 13.4 on
x86_64-w64-mingw32, compiled by gcc.exe (Rev5, Built by MSYS2 project)
10.3.0, 64-bit
2021-09-05 14:34:10.558 CEST [19060] LOG: could not translate host name
"''", service "5432" to address: Unknown host
2021-09-05 14:34:10.558 CEST [19060] WARNING: could not create listen
socket for "''"
2021-09-05 14:34:10.558 CEST [19060] FATAL: could not create any TCP/IP
sockets
2021-09-05 14:34:10.560 CEST [19060] LOG: database system is shut down

Any ideas on how to solve this ?

Esteban

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2021-09-05 13:32:55 Re: stat() vs ERROR_DELETE_PENDING, round N + 1
Previous Message Stephen Frost 2021-09-05 11:50:05 Re: New predefined roles- 'pg_read/write_all_data'