Re: Regression tests failures on Windows Server 2019 - on master at commit # d816f366b

Hi,

On 2022-03-04 12:23:43 -0500, Tom Lane wrote:
> Actually ... looking closer at the failure log:
> 
> [09:41:50.589] Checking plpgsql
> [09:41:50.608] (using postmaster on Unix socket, default port)
>                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> [09:41:50.608] ============== dropping database "pl_regression"      ==============
> [09:41:52.731] psql: error: connection to server at "localhost" (::1), port 5432 failed: Connection refused
(0x0000274D/10061)
> [09:41:52.731]     Is the server running on that host and accepting TCP/IP connections?
> [09:41:52.731] connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused
(0x0000274D/10061)
> [09:41:52.731]     Is the server running on that host and accepting TCP/IP connections?
> 
> pg_regress thinks the postmaster is listening to a Unix socket.
> Maybe it's *only* listening to a Unix socket.  In any case,
> psql has very clearly not been told to use a Unix socket.
> Something is not wired up correctly there.

I saw that too, but I don't think it's the primary problem. The server is
listening on ::1 as we know from the log, and quite evidently psql is trying
to connect to that too.  This output also looked this way before the failures.

pg_regress outputs the above message when neither PGHOST, PGPORT or
--host/--port are set. On windows that nevertheless ends up with connecting to
localhost.

Greetings,

Andres Freund