Dear sirs,
Here I am reporting an unexpected error in the course using version 14.5 pg_upgrade tool to upgrade some version 10.18
clusters.
In pg_upgrade_dump_1.log, the following content is collected.
Up to now this problem has been found in 3 database clusters out of around 500.
The PostgreSQL 14.5 binary tool is built using Visual Studio 2015 target to x64 architecture.
The launch to the pg_upgrade tool is done through Windows command prompt, by setting the PGUSER and PGPASSWORD
environmentvariable before the command calling pg_upgrade with proper folders.
I see the collected error as unexpected because this only happened to "template1" database, which is an internal
database.
In the same instance, there are records to other databases where pg_restore command runs successfully without error.
I also attached an archive of some other collected logs files generated by pg_upgrade tool in the same call instance
whenthe errors are reported.
Please see if it is feasible to start with investigation to resolve reported problem such that pg_ugprade tool can
upgradedatabase clusters without unexpected errors.
Best regards,
Ken
----------------------
command: "C:/Program Files/Exactal/CostXSvr/PostgreSQL/bin/pg_dump" --port 50432 --username postgres --schema-only
--quote-all-identifiers--binary-upgrade --format=custom --file="pg_upgrade_dump_1.custom" ^"dbname^=template1^" >>
"pg_upgrade_dump_1.log"2>&1
command: "C:/Program Files/Exactal/CostXSvr/PostgreSQL/bin/pg_restore" --port 50432 --username postgres --clean
--create--exit-on-error --verbose --dbname postgres "pg_upgrade_dump_1.custom" >> "pg_upgrade_dump_1.log" 2>&1
pg_restore: connecting to database for restore
pg_restore: error: connection to server at "localhost" (::1), port 50432 failed: FATAL: password authentication failed
foruser "postgres"