pg_upgrade port 50432 failed: fe_sendauth: no password supplied

731 Views Asked by At

I want to try my first upgrade from postgres 15.1 to 15.2

no instance is started,I run init on new dir:

    d:\_dev_\postgres\pgsql\bin\initdb.exe -D d:\_dev_\postgres\pgsql\data 
-U postgres -W -E UTF8 -A scram-sha-256

then

I've create a cmd file:

SET PGPASSWORD=xxxx
SET PATH=%PATH%;d:\_dev_\postgres\pgsql\bin;

pg_upgrade.exe 
--old-datadir "d:\_dev_\postgres\OLD_pgsql\data"
--new-datadir "d:\_dev_\postgres\pgsql\data"
--old-bindir "d:\_dev_\postgres\OLD_pgsql\bin"
--new-bindir "d:\_dev_\postgres\pgsql\bin"

but got:

Checking cluster versions                                   ok

connection to server at "localhost" (::1), port 50432 failed: FATAL:  password authentication failed for user "user"

    could not connect to source postmaster started with the command:
    "d:/_dev_/postgres/Vpgsql/bin/pg_ctl" -w -l "d:/_dev_/postgres/pgsql/data/pg_upgrade_output.d/20230210T102433.178/log/pg_upgrade_server.log" -D "d:/_dev_/postgres/Vpgsql/data" -o "-p 50432 -b " start
    Failure, exiting
0

There are 0 best solutions below