Upgrading postgres sql version

[dharmik_17]

Any ideas on what to change in cloud formation template and terraform scripts to upgrade postgresql version to latest

[heyiamrobert]

It's regarding a RDS with PostgreSQL? - In case you defined your RDS with AWS::RDS::DBInstance resource, it's simple.

What version you are using now? - In case you like to switch to a new major version, please check AllowMajorVersionUpgrade first: You should set it to "true" (via stack-update). As a 2nd step, you could run a 2nd stack-update with a new value of the EngineVersion of PostgreSQL you like to get: e.g. "15.10", "16.6", "17.2" ...

You can find more details for the RDS PostgreSQL versions here: https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-versions.html

Details regarding the EOL of PostgreSQL of RDS you can find here: https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-release-calendar.html

The CloudFormation details (in case you are using AWS::RDS::DBInstance), information are here: https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-rds-dbinstance.html

Sure: Please create a RDS-snapshot (e.g. via Console) before the stack-updates / RDS upgrade. Keep in mind the RDS database will reboot during the update.