Re: BUG #19392: PG_UPGRADE is non-functional on Windows - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #19392: PG_UPGRADE is non-functional on Windows
Date
Msg-id aYLsIfI-yf56z0b8@paquier.xyz
Whole thread Raw
In response to BUG #19392: PG_UPGRADE is non-functional on Windows  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
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

Attachment

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #19392: PG_UPGRADE is non-functional on Windows
Next
From: Andrew Dunstan
Date:
Subject: Re: BUG #19392: PG_UPGRADE is non-functional on Windows