Upgrading PostgreSQL 9.6 before EOL
You need to plan for the end-of-life (EOL) of PostgresSQL 9.6, announced by Amazon. As an AWS environment user, you need to check the version of PostgreSQL you use for Cloudera Data Warehouse environments. If your database version is still PostgreSQL 9.6, you need to upgrade to PostgreSQL 11.12.
You can initiate an upgrade of your database instance — either immediately or during your next maintenance window — to the Cloudera-recommended version of PostgreSQL 11.12 using the AWS Management Console or the AWS Command Line Interface. Follow the procedure below to perform the upgrade.
The upgrade process shuts down the database instance, performs the upgrade, and restarts the database instance. The database instance may be restarted multiple times during the upgrade process. While major version upgrades typically complete within the standard maintenance window, the duration of the upgrade depends on the number of objects within the database. To estimate the time required, take a snapshot of your database and test the upgrade.
Validate the upgrade to PostgreSQL 10.16
You need to connect to the postgres 10.16 database, and validate the upgrade.
Upgrade to PostgreSQL 11.12
- Go to the , and upgrade the Amazon RDS version to PostgreSQL 11.12.
- Rerun the basic queries in your Virtual Warehouse to validate the upgrade.