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?

已提问 5 年前925 查看次数
2 回答
-1

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
已回答 5 年前
  • There's absolutely no information in the logs.

-1

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.

已回答 5 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则