Cloud SQL for PostgreSQL - October 3rd, 2024 [Feature]

## Feature The `pg_ivm` extension, version 1.9, is generally available. This extension enables you to make materialized views up-to-date in which only incremental changes are computed and applied on views rather than recomputing the contents from scratch. Cloud SQL for PostgreSQL, version 16, now supports the `pgRouting` extension. This extension extends PostGIS and enhances geospatial processing through network routing and analysis. For more information on these extensions, see [Configure PostgreSQL extensions](https://cloud.google.com/sql/docs/postgres/extensions). The rollout of the following minor versions, extension versions, and plugin versions is **underway**: **Minor versions** * 12.19 is upgraded to 12.20. * 13.15 is upgraded to 13.16. * 14.12 is upgraded to 14.13. * 15.7 is upgraded to 15.8. * 16.3 is upgraded to 16.4. **Extension and plugin versions** * google\_ml\_integration is upgraded from 1.2 to 1.4.2. * pgvector is upgraded from 0.7.0 to 0.7.4. If you use a maintenance window, then the updates to the minor, extension, and plugin versions happen according to the timeframe that you set in the window. Otherwise, the updates occur within the next few weeks. The new maintenance version is `[PostgreSQL version].R20240910.01.00_02`. To learn how to check your maintenance version, see [Self service maintenance](https://cloud.google.com/sql/docs/postgres/self-service-maintenance#before%5Fyou%5Fbegin/self-service-maintenance). To find your maintenance window or to manage maintenance updates, see [Find and set maintenance windows](https://cloud.google.com/sql/docs/postgres/set-maintenance-window). ## Feature You can now configure server certificate authority (CA) mode when you create a Cloud SQL instance. With server CA mode, you have two options: * **Per-instance CA**: this is the default configuration. With this option, an internal CA dedicated to each Cloud SQL instance signs the server certificate for that instance. * **Shared CA**: with this option, the Cloud SQL instance uses a CA hierarchy consisting of a root CA and subordinate server CAs managed by Cloud SQL and hosted on Google Cloud Certificate Authority Service (CA Service). The subordinate server CAs in a region sign the server certificates and are shared across instances in the region. For more information about each option, see [Certificate authority (CA) hierarchies](https://cloud.google.com/sql/docs/postgres/authorize-ssl#certificate%5Fauthority%5Fca%5Fhierarchies). This feature is in [Preview](https://cloud.google.com/products#product-launch-stages).