Re: BUG #19392: PG_UPGRADE is non-functional on Windows

On Wed, Feb 04, 2026 at 02:29:19AM +0000, PG Bug reporting form wrote:
> connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no
> password supplied
> could not connect to source postmaster started with the command:
> "C:/postgresql16/bin/pg_ctl" -w -l
> "C:/postgresql18/data/pg_upgrade_output.d/20260204T130353.043/log/pg_upgrade_server.log"
> -D "C:/postgresql16/data" -o "-p 5432 -b " start
> Failure, exiting
>
> Note the quoting around the -o, -p and -b arguments.
> There should perhaps be TWO double-quotes after -o or it should not be
> present.
> There should not be a double-quote after -b

Why? pg_ctl -o is defined as an option to which is given a
string. This string includes a set of options to pass down to the
"initdb" or "postgres" commands kicked by pg_ctl when interacting with
a. In this case, "-p 5432 -b " looks like a valid option value to
me. This means to start a server with port 5432, disabling
autovacuum, something that pg_upgrade requires.
--
Michael