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 Answers
0
Accepted Answer

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.

J_N__
answered 15 days ago
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
Arpit
answered a month ago
profile pictureAWS
EXPERT
reviewed a month ago
  • 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
EXPERT
answered a month ago
  • I cannot see the issues

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