In the course of upgrading a bunch of database clusters from 10 to 14 using pg_upgrade tool, some databases result in the following error recorded in pg_upgrade_dump_1.log, such that cluster upgrade fails. FATAL: password authentication failed for user "postgres" This was done on Microsoft Windows 11. PostgreSQL 10 and 14 used are built using Visual Studio 2015. Only a small number of database clusters has this problem, around 2 of 200. It appears these database are used from earlier cluster upgrade from 9.4 to 10 as well. It would be very helpful if there is any possible workaround to overcome this problem. I attached a sample pg_upgrade_dump_1.log reported this error.
Attachment:
pg_upgrade_dump_1.log
Description: pg_upgrade_dump_1.log
