Ensure that your Google Cloud PostgreSQL database instances are using the latest major version of PostgreSQL database in order to receive new or enhanced features and the most recent security fixes.
The PostgreSQL open-source project regularly issues new releases that can be available to Google Cloud Platform (GCP) customers. By upgrading your GCP PostgreSQL database instances with the new version of PostgreSQL, you will introduce new software features, fix reported bugs through security patches, and provide better compatibility with other cloud applications and/or services. For example, PostgreSQL 11 represents a major version that includes a variety of improvements associated with partitioning, parallelism, stored procedures, covering indexes and other important performance enhancements.
Note: For PostgreSQL 9.6, the first two numbers in the version number form the major version number. For example, for version 9.6.1, Google Cloud uses 9.6 as the major version, and 1 as the minor version. For PostgreSQL 10 and above, the first number is the major version number. For example, for version 10.1, 10 is the major version number, and 1 is the minor version.
To determine if your Google Cloud PostgreSQL database servers are using the latest major version of PostgreSQL database, perform the following actions:
Remediation / Resolution
Automatic upgrade to a major PostgreSQL database version is not currently supported within Google Cloud Platform (GCP). To upgrade your Google Cloud PostgreSQL instances to the latest major version of the PostgreSQL database, you have to re-create the existing instance, export data from the existing (source) instance, and importing that data into a new (target) instance running the latest major version of PostgreSQL. To implement the rule remediation process, perform the following actions:Note: Before moving your data to a database instance running a newer version of PostgreSQL, you should familiarize yourself with the differences between the database engine versions by verifying the PostgreSQL official documentation.
- Google Cloud Platform (GCP) Documentation
- Cloud SQL for PostgreSQL
- Database version policies
- Release notes
- Upgrading PostgreSQL for an instance
- Creating instances
- Exporting data
- Importing data into Cloud SQL
- Deleting instances
Unlock the Remediation Steps
Gain free unlimited access
to our full Knowledge Base
Over 750 rules & best practices
You are auditing:
Check for PostgreSQL Major Version
Risk level: Low