| From: | Ken Yeung <Ken(dot)Yeung(at)rib-software(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters |
| Date: | 2022-07-11 05:37:51 |
| Message-ID: | VI1PR01MB4926A72FAD40EE99A353E7B7C0879@VI1PR01MB4926.eurprd01.prod.exchangelabs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Content-Type | Size |
|---|---|---|
| pg_upgrade_dump_1.log | application/octet-stream | 1.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Walter Dörwald | 2022-07-11 08:11:08 | Re: Get the table creation DDL |
| Previous Message | Rob Sargent | 2022-07-11 02:52:35 | Re: Get the table creation DDL |