Access log file from failed upgrade from PostgreSQL 10.7 to 11.2.

0

Trying to upgrade from PostgreSQL 10.7 to 11.2 with default configuration.

The upgrade runs for some times and then reverts back to 10.7 (luckily). The log file contains:

*failure*
There were problems executing ""/rdsdbbin/postgres/bin/pg_restore" --host /rdsdbdata/log/upgrade --port 8193 --username rdsadmin --create --exit-on-error --verbose --dbname template1 "pg_upgrade_dump_16404.custom" >> "pg_upgrade_dump_16404.log" 2>&1"
Consult the last few lines of "pg_upgrade_dump_16404.log" for
the probable cause of the failure.
"/rdsdbbin/postgres/bin/pg_ctl" -w -D "/rdsdbdata/db" -o "--config_file=/rdsdbdata/config_new/postgresql.conf" -m fast stop >> "pg_upgrade_server.log" 2>&1

*failure*
There were problems executing ""/rdsdbbin/postgres/bin/pg_restore" --host /rdsdbdata/log/upgrade --port 8193 --username rdsadmin --create --exit-on-error --verbose --dbname template1 "pg_upgrade_dump_13240846.custom" >> "pg_upgrade_dump_13240846.log" 2>&1"
Consult the last few lines of "pg_upgrade_dump_13240846.log" for
the probable cause of the failure.
"/rdsdbbin/postgres/bin/pg_ctl" -w -D "/rdsdbdata/db" -o "--config_file=/rdsdbdata/config_new/postgresql.conf" -m fast stop >> "pg_upgrade_server.log" 2>&1
child process exited abnormally: status 256
"/rdsdbbin/postgres/bin/pg_ctl" -w -D "/rdsdbdata/db" -o "--config_file=/rdsdbdata/config_new/postgresql.conf" -m fast stop >> "pg_upgrade_server.log" 2>&1
----------------------- END OF LOG ----------------------

However, the file pg_upgrade_dump_....log can not be found in the user interface.

Does anyone know how to find the root cause of this failure to restore the backup and finish the upgrade?

asked 5 years ago745 views
2 Answers
0

Hello,

If you take a look RDS events for your instance you can usually see upgrade failures as to why your instance was unable to be upgraded, or what error pg_upgrade ran into.

Best,
John H

AWS
answered 5 years ago
0

Thanks. Old events were already gone, so retried upgrade for third time after also enabling logging to cloudwatch of event and upgrade log.
This time upgrade to 11.2 succeeded without errors or downgrading again.

answered 5 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions