By using AWS re:Post, you agree to the Terms of Use
/How do I find out when a minor version upgrade occurred in an RDS?/

How do I find out when a minor version upgrade occurred in an RDS?

0

Saw that a PostgreSQL RDS is now in 10.18 version. It was in 10.14 version. Do not know how to track when this upgrade occurred.

2 Answers
0
Accepted Answer

Hi Amazon RDS for PostgreSQL Supports New Minor Versions 10.18 available on Oct 1, 2021.

https://aws.amazon.com/about-aws/whats-new/2021/10/amazon-rds-postgresql-new-minor-versions-amazon-rds-outposts-postgresql-minor-versions/

If auto minor version update is enabled, it will happen during the RDS instance's scheduled maintenance time. Do you know when your RDS instance's Auto Minor version is actually enabled? You might want to take a look at the events in your cloud formation stack or the API requests you've made. If you want to figure out when this RDS upgrade happened. You can access your RDS recent events through the AWS Management Console, which shows events from the previous 24 hours, You can also view events from the past 14 days using the AWS CLI or the RDS API. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ListEvents.html

answered 2 months ago
  • Hi, Sorry for taking so long to thank you for the information. Managed to look up the last 14 days using AWS CLI.

0

Hi,

Minor upgrades take place during the scheduled maintenance window setup for your RDS instance. Upgrades will be scheduled to RDS as soon as AWS release them.

You may also want to check out the DescribePendingMainteananceActions API to see what maintenance is pending for your cluster. https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_DescribePendingMaintenanceActions.html

answered 2 months ago
  • Hi, Thanks for the information, but the way we can setup automatic minor version upgrades was of my knowledge. I read in some questions here, thought, that not always minor versions are upgraded, event if the automatic application is enabled. In the RDS I am trying to analyze, the minor version was available and had been recommended to be upgraded for a while already. But only today, it seems, it was actually applied. So, wanted to track when it occurred to understand what exactly triggered its application only today. Thanks

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