Issue was with stepfunction, that disables RDS at nights.
The issue might be that you have set your preferred maintenance window options correctly but maintenance takes place every after 7 days. I believe that it is not a global issue.
There are also two types of versioning namely minor and major version. A major engine version upgrade can introduce changes that are not compatible with existing applications. While a minor upgrade includes only changes that are backward-compatible with existing applications. A minor engine version is an update to a DB engine version within a major engine version and updates can be automatically applied by RDS.
When creating you database under additional configuration navigate to Maintenance make sure that auto minor version upgrade is enable by enabling auto minor version upgrade will automatically upgrade to new minor versions as they are released. The automatic upgrades occur during the maintenance window for the database. So you need to select the period you want pending modifications or maintenance applied to the database by Amazon RDS do specify a preferred maintenance window when you create the DB instance, by selecting “choose window” and set time and duration of your choice. Then create your database.
Please kindly refer to the following documents for more Information about operating system updates for RDS for PostgreSQL : https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Maintenance.html and https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html#USER_UpgradeDBInstance.PostgreSQL.MajorVersion
Hi. I raised this error with AWS team. I am waiting for a resolution.
[Announcement] Amazon Aurora PostgreSQL 9.6 End of life is January 31, 2022asked a year ago
How to upgrade Lightsail Postgres instance? (minor version upgrade)asked 2 months ago
Aurora Postgres cluster failed to upgrade from 13.4 to 13.4.2 at maintenance windowAccepted Answerasked 7 months ago
Aurora cluster maintenance window and minor version upgradesasked a year ago
Bug in RDS UI: Maintenance Apply date isn't shown immediately after setting itasked 3 months ago
How can I update the maintenance window and apply the new features or new ONTAP version for FSx for ONTAP earlier than existing weekly maintenance window?Accepted Answerasked a year ago
[Announcement] Extension to Mandatory Upgrade Schedule for Amazon Auroraasked 5 years ago
Aurora PostgresSQL major version upgradeasked 23 days ago
I received an email on November 16, 2021 to notify an event about RDS OS security upgrade.asked 10 months ago
[Announcement] Upgrade Amazon Aurora PostgreSQL 10.13, 10.14, 10.16, 11.8, 11.11, 12.4, and 12.6 minor versions by July 15, 2022asked 7 months ago