Where is precheck log file for Aurora Serverless Postgres?

0

We just received an ultimatum to upgrade our Aurora Serverless Postgres from version 11 due to end-of-life. I tried to upgrade to version 13, which fails:

Database cluster is in a state that cannot be upgraded: PreUpgrade checks failed: The cluster could not be upgraded because one or more databases have settings or usages that are not compatible with the target engine version. Please check the precheck log file for more details

I cannot find this precheck log file. It is not in the Logs & events section, which basically only contains the above text.

BR. Joni

3 個答案
0
已接受的答案

Ended up creating a 'physical' clone. Tried the upgrade on it, and now I could check the logs.

Ends up that PostGIS is practically not upgradeable. So I dumped the database with PostGIS, dropped it, upgraded the server, and imported the tables from the dump.

已回答 2 個月前
0

Enable Enhanced Monitoring for your Aurora Serverless cluster, which will send logs and metrics to Amazon CloudWatch Logs. You can then access and analyze these logs using the CloudWatch Logs console or the AWS CLI.

To enable Enhanced Monitoring, follow these steps:

In the RDS console, select your Aurora Serverless PostgreSQL cluster. Choose "Modify" from the "Actions" dropdown. In the "Monitoring" section, enable "Enhanced Monitoring." Apply the changes. After enabling Enhanced Monitoring, you can access the logs in CloudWatch Logs by looking for the log group named /aws/rds/cluster/your-cluster-name/postgresql.

So, in summary, for Aurora Serverless PostgreSQL clusters, you cannot directly access the pre-check log file or the underlying file system. Instead, you need to rely on the RDS console, Enhanced Monitoring, and CloudWatch Logs to view and analyze logs related to your cluster.

AWS
已回答 2 個月前
profile pictureAWS
專家
已審閱 2 個月前
  • There is no Monitoring section available?

  • "This is your final notification for Aurora PostgreSQL 11 clusters that are not upgraded before October 15, 2024. The clusters will be stopped until the cluster has been successfully upgraded to a current supported version of PostgreSQL." Thanks a lot AWS

0

Hi,

Please, follow this KC article to fix issues with pre-upgrade checks: https://repost.aws/knowledge-center/rds-postgresql-version-upgrade-issues

Best,

Didier

profile pictureAWS
專家
已回答 2 個月前
  • I cannot see the issues

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南