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