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 réponses
0
Réponse acceptée

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.

répondu il y a 2 mois
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
répondu il y a 2 mois
profile pictureAWS
EXPERT
vérifié il y a 2 mois
  • 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
répondu il y a 2 mois
  • I cannot see the issues

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions