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