From: | Ken Yeung <Ken(dot)Yeung(at)rib-software(dot)com> |
---|---|
To: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | using 14.5 pg_upgrade on version 10.18 clusters reports unexpected error occasionally |
Date: | 2022-09-07 08:43:27 |
Message-ID: | VI1PR01MB4926927DCBF6AE0827514390C0419@VI1PR01MB4926.eurprd01.prod.exchangelabs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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 environment variable 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 when the errors are reported.
Please see if it is feasible to start with investigation to resolve reported problem such that pg_ugprade tool can upgrade database 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 for user "postgres"
Attachment | Content-Type | Size |
---|---|---|
pg_upgrade_fail_logs.zip | application/x-zip-compressed | 69.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Sandeep Thakkar | 2022-09-07 09:54:28 | Re: BUG #17603: Problem running the post-install step. Installation may not complete correctly. |
Previous Message | Sandeep Thakkar | 2022-09-07 02:24:16 | Re: BUG #17603: Problem running the post-install step. Installation may not complete correctly. |