You can see the latest product updates for all of Google Cloud on the Google Cloud page, browse and filter all release notes in the Google Cloud console, or you can programmatically access release notes in BigQuery.
To get the latest product updates delivered to you, add the URL of this page to your
feed
reader, or add the feed URL directly: https://cloud.google.com/feeds/cloud-sql-postgres-release-notes.xml
June 02, 2023
The rollout of the following minor versions, extension versions, and plugin versions is currently underway:
Minor versions
- 10.22 is upgraded to 10.23.
- 11.17 is upgraded to 11.19.
- 12.12 is upgraded to 12.14.
- 13.8 is upgraded to 13.10.
- 14.5 is upgraded to 14.7.
Extension and plugin versions
- pg_cron is upgraded from 1.4.1 to 1.5.
- pg_partman is upgraded from 4.7.0 to 4.7.3.
- postgresql-hll is upgraded from 2.16 to 2.17.
- pg_repack is upgraded from 1.4.7 to 1.4.8.
- wal2json is upgraded from 2.4 to 2.5.
- pg_hint_plan is upgraded, as follows:
- from 1.3.7 to 1.3.8 (for PostgreSQL versions 11-13)
- from 1.4.0 to 1.4.1 (for PostgreSQL version 14)
- from 1.4.0 to 1.5.0 (for PostgreSQL version 15)
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].R20230530.01_00. To learn how to check your maintenance version, see Self service maintenance. To find your maintenance window or to manage maintenance updates, see Find and set maintenance windows.
May 24, 2023
PostgreSQL version 15 is now generally available. To start using PostgreSQL 15, see Create instances.
May 19, 2023
The following extensions, views, utilities, and flags are generally available:
Extensions
- postgresql_anonymizer: mask or replace personally identifiable information (PII) or sensitive data from a PostgreSQL database.
- pgtt: create, manage and use Oracle-style global temporary tables.
- rdkit: compare, manipulate, and identify molecular structures.
Views and utilities
- pg_authid: access this catalog table that contains hashed passwords and other properties for all database roles.
- pg_dumpall: extract all PostgreSQL databases of a cluster into a single script file.
Flags
- log_line_prefix: generate a printf-style string at the beginning of each line of a PostgreSQL log file.
The rollout of the following minor versions, extension versions, and plugin versions is currently underway:
Minor versions
- 10.21 is upgraded to 10.22.
- 11.16 is upgraded to 11.17.
- 12.11 is upgraded to 12.12.
- 13.7 is upgraded to 13.8.
- 14.4 is upgraded to 14.5.
Extension and plugin versions
- plv8 is upgraded from 3.1.2 to 3.1.4.
- wal2json is upgraded from 2.3 to 2.4.
- pgTAP is upgraded from 1.1.0 to 1.2.0.
- PostGIS is upgraded from 3.1.4 to 3.1.7.
- pg_partman is upgraded from 4.5.1 to 4.7.0.
- pg_wait_sampling is upgraded from 1.1.3 to 1.1.4.
- pg_hint_plan is upgraded from 1.3.7 to 1.4.
- pglogical is upgraded from 2.4.1 to 2.4.2.
This rollout also introduces the following:
- PostGIS GDAL driver support
- LZ4 TOAST compression for PostgreSQL versions 14 and later
May 16, 2023
The Cloud SQL Proxy Operator is now generally available. To learn more about the Cloud SQL Proxy Operator, see About the Cloud SQL Proxy Operator.
May 02, 2023
Fast migration for Cloud SQL is now available. This feature improves the performance of data migrations from an external source to a destination Cloud SQL instance.
April 15, 2023
The changes listed in the March 29th release notes entry for PostgreSQL minor versions, extension versions, and plugin versions have been postponed.
April 06, 2023
Cascading Replicas is now generally available when migrating from external servers. You can now configure migrated replicas to have read replicas under them before promoting them to primary replica. To learn more, see External Server Cascading Replicas.
March 30, 2023
Support for me-central1 (Doha) region.
March 29, 2023
The rollout of the following PostgreSQL minor versions, extension versions, and plugin versions is currently underway:
Minor versions
- 10.21 is upgraded to 10.22.
- 11.16 is upgraded to 11.17.
- 12.11 is upgraded to 12.12.
- 13.7 is upgraded to 13.8.
- 14.4 is upgraded to 14.5.
Extension and plugin versions
- plv8 is upgraded from 3.1.2 to 3.1.4.
- wal2json is upgraded from 2.3 to 2.4.
- pgTAP is upgraded from 1.1.0 to 1.2.0.
- PostGIS is upgraded from 3.1.4 to 3.1.7.
- pg_partman is upgraded from 4.5.1 to 4.7.0.
- pg_wait_sampling is upgraded from 1.1.3 to 1.1.4.
- pg_hint_plan is upgraded from 1.3.7 to 1.4.
- pglogical is upgraded from 2.4.1 to 2.4.2.
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].R20230316.02_02. To learn how to check your maintenance version, see Self service maintenance. To find your maintenance window or to manage maintenance updates, see Find and set maintenance windows.
March 28, 2023
The changes in the September 15, 2022 Release Notes entry for read replica maintenance are now available. Cloud SQL read replicas follow the maintenance settings for the primary instance, including the maintenance window, rescheduling, and the deny maintenance period. During the maintenance event, Cloud SQL maintains the replicas before maintaining the primary instance. For more information, see How does maintenance affect read replicas?
March 23, 2023
Support for europe-west12 (Turin) region.
March 21, 2023
Smaller read replicas are now available for Cloud SQL. Read replicas no longer require the same or more CPUs and RAM than their primary instances.
February 28, 2023
Cloud SQL now supports the ability to get details for a Cloud SQL user for a database instance using the API or gcloud. To learn more about the new method, see Cloud SQL Admin API REST Resource.
February 24, 2023
The Cloud SQL Proxy Operator is now available in public preview. The Cloud SQL Proxy Operator is an open-source Kubernetes operator that automates connecting workloads in a GKE cluster to Cloud SQL databases. To learn more about the Cloud SQL Proxy Operator, see About the Cloud SQL Proxy Operator.
February 08, 2023
The Cloud SQL Auth proxy is a utility for ensuring secure connections to your Cloud SQL instances. The v2 release offers improvements in performance, stability, and telemetry. Among the new features, there's support for:
- Metrics and tracing with Cloud Monitoring and Cloud Trace
- Support for Prometheus
- Service account impersonation
- Separate Dialer functionality released as the Cloud SQL Go Connector
- Configuration with environment variables
- Fully POSIX-compliant flags
We recommend all customers upgrade to v2 and have released a migration guide. For more information, see Cloud SQL Auth proxy.
February 02, 2023
Cloud SQL supports the preview version of the Underprovisioned instance recommender. This service helps you avoid bottlenecks from high CPU and memory usage and minimize the likelihood of out-of-memory events. It gives you recommendations to resize your instances to a machine tier that better suits your workload.
January 18, 2023
Cloud SQL now supports viewing an audit log for an automated backup of an instance to verify whether the backup is completed successfully. You can also configure a log-based alert so that a user can be notified of the backup's status.
January 09, 2023
For new Cloud SQL instances that have point-in-time recovery enabled or for existing instances that enable point-in-time recovery, Cloud SQL for PostgreSQL now stores write-ahead logs in Google Cloud Storage.
Before this release, write-ahead logs, which are used to perform point-in-time recovery, were stored on disk. Now, logs are stored in Google Cloud Storage in the same region as the instances.
All other existing instances that have point-in-time recovery enabled will continue to have their logs stored on disk. The change to storing logs in Google Cloud Storage will be made available at a later time.
December 15, 2022
You can now allow other Google Cloud services, such as BigQuery, to access data in Cloud SQL for PostgreSQL and make queries against this data over a private connection. For more information, see Create instances.
December 13, 2022
The Cloud SQL System insights dashboard now shows additional metrics and an events timeline. You can also use the Auto refresh function to keep the dashboard up to date.
December 01, 2022
The changes listed in the October 19th release notes entry for PostgreSQL minor versions, extension versions, and plugin versions have been postponed.
October 28, 2022
The changes listed in the September 15 Release Notes entry for read replica maintenance have been postponed.
October 19, 2022
The rollout of the following PostgreSQL minor versions, extension versions, and plugin versions is currently underway:
Minor versions
- 10.21 is upgraded to 10.22.
- 11.16 is upgraded to 11.17.
- 12.11 is upgraded to 12.12.
- 13.7 is upgraded to 13.8.
- 14.4 is upgraded to 14.5.
Extension and plugin versions
- plv8 is upgraded from 3.1.2 to 3.1.4.
- wal2json is upgraded from 2.3 to 2.4.
- pgTAP is upgraded from 1.1.0 to 1.2.0.
- PostGIS is upgraded from 3.1.4 to 3.1.7.
In addition, this rollout introduces the following changes to collation support:
- The
C.UTF-8collation is renamed toC.utf8. The original name is supported as an alias of the new name. The following collations aren't supported anymore:
as_IN.utf8az_AZ.utf8ca_ES.utf8@valenciaeo.utf8iaiw_ILiw_IL.utf8pap_ANtt_RU.utf8tt_RU.utf8@iqtelif
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].R20221017.01_00. To learn how to check your maintenance version, see Self service maintenance. To find your maintenance window or to manage maintenance updates, see Find and set maintenance windows.
October 11, 2022
Cloud SQL supports the preview version of the high transaction ID utilization recommender that helps you avoid potential transaction ID wraparound for Cloud SQL for PostgreSQL instances.
October 05, 2022
Cloud SQL for PostgreSQL now supports the log_timezone and TimeZone flags. For more information, see the Configure database flags page.
October 04, 2022
Terraform is supported when you use self-service maintenance.
September 30, 2022
Cloud SQL for PostgreSQL supports in-place major version upgrades in GA. You can upgrade your instance's major version to a more recent version. For more information, see Upgrade the database major version in-place.
September 21, 2022
Cloud SQL allows the re-use of an instance name immediately after the instance is deleted. For more information, see the Cloud SQL for PostgreSQL FAQ.
September 15, 2022
Cloud SQL read replicas now follow the maintenance settings for the primary instance, including the maintenance window, rescheduling, and the deny maintenance period. During the maintenance event, Cloud SQL maintains the replicas before maintaining the primary instance. For more information, see How does maintenance affect read replicas?
September 13, 2022
Support for me-west1 (Tel Aviv).
September 12, 2022
Cascading Replicas is now generally available for Cloud SQL. Customers can now configure PostgreSQL and MySQL for Cloud SQL read replicas to have read replicas under them.
August 26, 2022
The following extensions in Cloud SQL for PostgreSQL are generally available:
- pgRouting. Enhances geospatial processing, through network routing and analysis, for PostGIS.
- plv8. Provides a procedural language for enabling the use of JavaScript.
- amcheck. Enables the use of the pg_amcheck application to check for corruption in PostgreSQL databases.
August 15, 2022
By enabling instance deletion protection, you can prevent the accidental removal of Cloud SQL instances. This functionality is generally available.
For more information, see Prevent deletion of an instance.
August 05, 2022
The new Cloud SQL System insights dashboard helps you detect and analyze system performance problems.
July 29, 2022
For PostgreSQL versions 9.6 to 13, the [PostgreSQL version].R20220710.01_00 maintenance version caused a behavior change for configuration parameters: Session-level configuration parameters with dashes (-) cannot be set.
After you check your current maintenance version, you can apply a fix by performing a self-service maintenance update to the latest release.
Please use this table to find the name of the maintenance version to apply, and use that version or the latest version available:
| PostgreSQL version | Maintenance version |
|---|---|
| PostgreSQL 9.6 | POSTGRES_9_6_24.R20220710.01_02 |
| PostgreSQL 10 | POSTGRES_10_21.R20220710.01_02 |
| PostgreSQL 11 | POSTGRES_11_16.R20220710.01_02 |
| PostgreSQL 12 | POSTGRES_12_11.R20220710.01_02 |
| PostgreSQL 13 | POSTGRES_13_7.R20220710.01_02 |
After you have identified the name of the maintenance version, please upgrade to the target maintenance version, performing the corresponding update of your instances (to the latest maintenance version).
Note that newly created instances automatically use the latest version.
July 25, 2022
The following PostgreSQL minor versions and extension versions are now available:
- 14.3 is upgraded to 14.4.
- 13.6 is upgraded to 13.7.
- 12.10 is upgraded to 12.11.
- 11.15 is upgraded to 11.16.
- 10.20 is upgraded to 10.21.
If you use maintenance windows, then you might not yet have these versions. In this case, you'll see the new versions after your maintenance update occurs. To find your maintenance window or to manage maintenance updates, see Find and set maintenance windows.
Added information about checking the LC_COLLATE value for your databases before performing a major version upgrade of the databases for your Cloud SQL for PostgreSQL instance. For more information, refer to the Cloud SQL documentation.
July 11, 2022
You can enable high availability for read replicas. See Disaster recovery for additional information about the use of high-availability replicas in a disaster recovery configuration.
You can create external server replicas with HA enabled.
July 08, 2022
The July maintenance changelog is now available. For more information, use the links at Maintenance changelog.
June 28, 2022
A second June maintenance changelog is now available. For more information, use the links at Maintenance changelog.
The fix to the silent data corruption when using the CREATE INDEX CONCURRENTLY or REINDEX CONCURRENTLY SQL commands in PostgreSQL 14 (BUG #17485) is now available in the self-service maintenance release POSTGRES_14_2.R20220331.02_012 for PostgreSQL 14.2.
After applying the self service maintenance, you can fix any silent data corruption if it already happens using REINDEX CONCURRENTLY SQL command on the specific indexes, or reindexdb client command for your entire instance.
June 23, 2022
Cloud SQL for PostgreSQL now supports replication from an external server.
June 14, 2022
For enhanced security with built-in authentication, Cloud SQL now lets you set password policies at the instance level.
June 13, 2022
The following extensions in Cloud SQL for PostgreSQL are generally available:
- pg_bigm. Enables full text search and allows a two-gram (bigram) index for faster full text search.
- refint. Enables the checking of foreign key restraints, the referencing table, and the referenced table.
- decoderbufs. A logical decoder that delivers output data as Protocol Buffers, adapted for Debezium.
- pg_wait_sample. Collects sampling statistics of wait events, providing wait event data for processes on servers.
Additionally, users with the cloudsqlsuperuser role have full access to the pg_largeobject system catalog.
Cloud SQL enables you to access to the pg_shadow view. You can use the pg_shadow view to work with the properties of roles that are marked as rolcanlogin in the pg_authid catalog.
For more information, see Access to the pg_shadow view.
June 10, 2022
Cloud SQL now supports faster machine type changes, with connectivity dropping to less than 60 seconds. For more information, see Impact of changing instance settings.
June 09, 2022
The June maintenance changelog is now available. For more information, use the links at Maintenance changelog.
June 08, 2022
New maintenance versions are now available through self-service maintenance. See the maintenance changelog to learn more about these new maintenance versions.
An addendum to the May maintenance changelog shows additional security patches. For more information, use the links at Maintenance changelog.
June 07, 2022
Support for us-south1 (Dallas).
May 24, 2022
Support for us-east5 (Columbus).
May 04, 2022
Support for europe-west9 (Paris).
May 02, 2022
New maintenance versions are now available through self-service maintenance. See the maintenance changelog to learn more about these new maintenance versions.
April 28, 2022
The following Cloud SQL recommenders that help you optimize your database costs are now generally available:
Idle database instance recommender: Identifies idle database instances in your project and provides recommendations about the savings that you can make by shutting them down.
Overprovisioned database instance recommender: Identifies overprovisioned database instances in your project and provides recommendations about the savings that you can make by rightsizing these instances.
April 25, 2022
You can now accept a maintenance update on your instance outside of the normal flow of scheduled maintenance.
While Cloud SQL schedules maintenance updates once every few months to ensure you have the latest maintenance version, you might want to use self-service maintenance if:
- You need an update sooner than your next scheduled maintenance event.
- You want to catch up to the latest maintenance version after skipping your most recent scheduled maintenance event.
- You want to gain more control over when maintenance is applied
Cloud SQL now supports maintenance changelogs. Maintenance changelogs provide information about updates available in new maintenance versions, such as database minor version upgrades and patches for security vulnerabilities. For links to current maintenance changelogs for each major database version, see Cloud SQL maintenance changelogs.
The following PostgreSQL minor versions and extension versions are now available. If you use maintenance windows, you might not yet have these versions. In this case, you will see the new versions after your maintenance update occurs. To find your maintenance window or manage maintenance updates, see Finding and setting maintenance windows.
- 14.1 is upgraded to 14.2.
- 13.5 is upgraded to 13.6.
- 12.9 is upgraded to 12.10.
- 11.14 is upgraded to 11.15.
- 10.19 is upgraded to 10.20.
April 20, 2022
Support for europe-west8 region (Milan).
April 12, 2022
Customer-managed encryption key (CMEK) organization policy constraints are now available in Preview.
constraints/gcp.restrictNonCmekServicesallows you to control which resources require the use of CMEK.constraints/gcp.restrictCmekCryptoKeyProjectsallows you to control the projects from which a Cloud KMS key can be used to validate requests.
You can use both constraints together to enforce the use of CMEK from allowed projects.
To learn more, see Customer-managed encryption keys (CMEK) organization policies. To add CMEK organization policies now, see Add Cloud SQL organization policies.
April 11, 2022
Cloud SQL for PostgreSQL supports in-place major version upgrades in Preview. You can upgrade your instance's major version to a more recent version. For more information, see Upgrade the database major version in-place.
February 24, 2022
Due to a change in a recent maintenance update, the changes listed in the February 4 Release Notes entry have been applied to some instances but postponed for the others. In the Google Cloud Console, you can determine if the maintenance update was applied. Specifically, on the Instance Overview page, review the instance's operations and logs for an occurrence of a maintenance operation since January 27.
February 23, 2022
If your primary instance uses a private IP address, you can now select an allocated IP range for clones and replicas created from the instance.
February 17, 2022
Cloud SQL now supports the use of tags on instances. Tags are key-value pairs you can apply to your resources, such as a project or a Cloud SQL instance, which are used for fine-grained access control. To learn more, see Access control with Google Cloud tags. To use tags now, see Attach and manage tags on Cloud SQL instances.
February 08, 2022
Cloud SQL supports the max_parallel_maintenance_workers, max_parallel_workers,
max_parallel_workers_per_gather, and max_pred_locks_per_transaction flags:
max_parallel_maintenance_workerssets the maximum number of parallel workers that can be started by a single utility command.max_parallel_workerssets the maximum number of workers that the system can support for parallel operations.max_parallel_workers_per_gathersets the maximum number of workers that can be started by a single Gather or Gather Merge node.max_pred_locks_per_transactioncontrols the average number of object locks allocated for each transaction.
For more information, see Supported flags.
February 07, 2022
Cloud SQL supports the wal_receiver_timeout and wal_sender_timeout flags:
- The
wal_receiver_timeoutflag ends replication connections that are inactive for the specified time. - The
wal_sender_timeoutflag, which is for detection by the ending server, ends replication connections that are inactive for the specified time.
For more information, see Supported flags.
February 04, 2022
The following PostgreSQL minor versions and extension versions are now available. If you use maintenance windows, you might not yet have these versions. In this case, you will see the new versions after your maintenance update occurs. To find your maintenance window or manage maintenance updates, see Finding and setting maintenance windows.
- 14.0 is upgraded to 14.1.
- 13.4 is upgraded to 13.5.
- 12.8 is upgraded to 12.9.
- 11.13 is upgraded to 11.14.
- 10.18 is upgraded to 10.19.
- 9.6.23 is upgraded to 9.6.24.
Additionally, the following extensions have been upgraded. For more information about these and other extensions, see PostgreSQL extensions.
- The pglogical extension is upgraded to 2.4.1.
The pgaudit extension is upgraded as follows:
- For PostgreSQL 14, upgraded to 1.6.1.
- For PostgreSQL 13, upgraded to 1.5.1.
- For PostgreSQL 12, upgraded to 1.4.2.
- For PostgreSQL 11, upgraded to 1.3.3.
- For PostgreSQL 10, upgraded to 1.2.3.
- For PostgreSQL 9.6, upgraded to 1.1.4.
February 01, 2022
Query Insights lets you configure the query sampling rate. For information, see Using Query Insights to improve query performance.
January 31, 2022
The Key Access Justifications (KAJ) feature is now generally available in Cloud SQL. You can use KAJ as part of Cloud External Key Manager (EKM). KAJ enables you to view the reason for each Cloud EKM request. Additionally, based on the justification provided, you can automatically approve or deny a request. For related information, see the Overview.
December 16, 2021
You can now see the database minor version when viewing information about an instance. See Database versions and version policies for a list of the latest supported versions.
December 15, 2021
PostgreSQL version 14 is now generally available. To start using PostgreSQL 14, see Create instances.
December 09, 2021
Cloud SQL now limits the rate for backup and restore operations on the data disk. For more information, see Backup rate limitations and Restore rate limitations.
November 19, 2021
The following extensions in Cloud SQL for PostgreSQL are generally available:
- auto_explain. Enables you to automatically log execution plans of slow statements, for troubleshooting and more. Provides an automated way to perform the functionality of the EXPLAIN command.
- pg_cron. A cron-based job scheduler, this extension enables cron syntax to schedule commands from a database.
- pg_hint_plan. Enables you to improve PostgreSQL execution plans using hints, which are simple descriptions in SQL comments.
- pg_proctab. Enables you to use pg_top with Cloud SQL for PostgreSQL, and generate reports from the operating system process table.
November 16, 2021
Support for southamerica-west1 (Santiago) region.
October 29, 2021
- The following PostgreSQL minor versions and extension versions are now available. If you use maintenance windows, you might not yet have these versions. In this case, you will see the new versions after your maintenance update occurs. To find your maintenance window or manage maintenance updates, see Finding and setting maintenance windows.
- 9.6.22 is upgraded to 9.6.23.
- 10.17 is upgraded to 10.18.
- 11.12 is upgraded to 11.13.
- 12.7 is upgraded to 12.8.
- 13.3 is upgraded to 13.4.
- The hll extension is upgraded to 2.16.
- The pglogical extension is upgraded to 2.4.0.
- The pg_partman extension is upgraded to 4.5.1.
- The pg_repack extension is upgraded to 1.4.7.
October 26, 2021
Cloud SQL now supports the max_pred_locks_per_page and max_pred_locks_per_relation flags. For information about the Cloud SQL implementation of these flags, see Supported flags.
October 08, 2021
Access Approval is now GA for Cloud SQL. Access Approval enables you to require explicit approval before Google Support may access your database for support purposes.To learn about access approval, see Overview of Access Approval. To set up access approval now, see the Access Approval Quickstart.
September 28, 2021
Cloud SQL supports the preview version of two recommenders that help you optimize your database costs:
Idle database instance recommender: Identifies idle database instances in your project and provides recommendations about the savings that you can make by shutting them down.
Overprovisioned database instance recommender: Identifies overprovisioned database instances in your project and provides recommendations about the savings that you can make by rightsizing these instances.
When a database instance is nearly out of storage capacity, it's automatically stopped to prevent the loss of information. For more information, see Stopping an instance.
September 14, 2021
Cloud SQL for PostgreSQL has enhanced the support for multiline log entries in postgres.log. Before, when a log entry spanned multiple lines, each line was recorded as a separate entry in Cloud Logging. The lines are now recorded as a single entry in Cloud Logging for ease of query and processing.
Cloud SQL for PostgreSQL now supports custom formatting controls for CSVs. For more information on how to select custom characters for field delimiters, quotes, escapes, and other characters in admin exports and imports, see our documentation.
September 10, 2021
The Cloud SQL out-of-disk recommender is now generally available. This feature proactively generates recommendations that help you reduce the risk of downtime that might be caused by your instances running out of disk space.
Cloud SQL for PostgreSQL now supports the min_wal_size flag. For more information about this flag, see the Cloud SQL for PostgreSQL flags documentation.
August 30, 2021
Cloud SQL for PostgreSQL support for pglogical, native logical replication, and change data capture (CDC) using wal2json and test_decoding is now generally available.
Cloud SQL for PostgreSQL support for Automatic IAM database authentication is now generally available. See Automatic IAM database authentication.
August 27, 2021
Cloud SQL for PostgreSQL now supports the following flags:
- huge_pages
- shared_buffers
- wal_buffers
For more information about these flags, see the Cloud SQL for PostgreSQL flags documentation.
August 21, 2021
Cloud SQL now supports IAM Conditions.
You can use IAM Conditions to define and enforce conditional, attribute-based access control for Google Cloud resources, including Cloud SQL instances. See Overview of IAM Conditions for more information.
August 17, 2021
Cloud SQL now offers faster maintenance, with connectivity dropping for less than 30 seconds on average.
August 09, 2021
The Cloud SQL Admin API v1 is now generally available. It is and will continue to be compatible with the v1beta4 version. There is no requirement to migrate from v1beta4 to the v1 Admin API.
August 03, 2021
Support for northamerica-northeast2-a,b,c (Toronto) region.
July 29, 2021
- Cloud SQL for PostgreSQL now supports the following flags:
- tcp_keepalives_count
- tcp_keepalives_idle
- tcp_keepalives_interval
For more information about these flags, see the Cloud SQL for PostgreSQL flags documentation.
July 26, 2021
- The following PostgreSQL minor versions and extension versions are now available. If you use maintenance windows, you might not yet have these versions. In this case, you will see the new versions once your maintenance update occurs. To find your maintenance window or manage maintenance updates, see Finding and setting maintenance windows.
- 9.6.21 is upgraded to 9.6.22.
- 10.16 is upgraded to 10.17.
- 11.11 is upgraded to 11.12.
- 12.6 is upgraded to 12.7.
- 13.2 is upgraded to 13.3.
- pglogical extension is upgraded to 2.3.4.
- PostGIS extension is upgraded to 3.0.3 for all PostgreSQL major versions.
June 29, 2021
Support for asia-south2 (Delhi) region.
June 23, 2021
Cloud SQL storage limits are now increased to support up to 64 TB. See Cloud SQL storage limits for more information.
June 21, 2021
Support for australia-southeast2 (Melbourne) region.
June 17, 2021
Query Insights is now supported for read replicas.
June 07, 2021
Cloud SQL now offers faster maintenance, with connectivity dropping for less than 60 seconds on average.
June 04, 2021
Both the Cloud SQL Java Connector and Cloud SQL Python Connector now support IAM Authentication for PostgreSQL.
June 01, 2021
The logical replication and decoding functionality of PostgreSQL is available as a preview. These features enable logical replication workflows and change data capture workflows.
For more information, see Setting up logical replication and decoding.
Cloud SQL for PostgreSQL now supports the pg_similarity extension, which provides support for similarity queries in PostgreSQL.
Also, the default value for the database flag autovacuum_vacuum_cost_delay is changed to 2 milliseconds in PostgreSQL 9.6, 10 and 11.
The minor versions for various extensions have also been upgraded:
| 9.6 | 10 | 11 | 12 | 13 | |
|---|---|---|---|---|---|
| address_standardizer | not avail | 2.4.9 | 2.5.5 | 3.0.2 | 3.0.2 |
| hll | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 |
| pg_repack | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 |
| pgaudit | 1.1.3 | 1.2.3 | 1.3.2 | 1.4.1 | no change |
| pglogical | 2.3.3 | 2.3.3 | 2.3.3 | 2.3.3 | 2.3.3 |
| pl/proxy | 2.10.0 | 2.10.0 | 2.10.0 | 2.10.0 | 2.10.0 |
| postgis | 2.3.11 | 2.4.9 | 2.5.5 | 3.0.2 | 3.0.2 |
May 19, 2021
Cloud SQL supports the preview version of the out-of-disk recommender. This feature proactively generates recommendations that help you reduce the risk of downtime that might be caused by your instances running out of disk space. These recommendations can be applied when a Cloud SQL instance is trending towards the storage limit.
April 23, 2021
The following PostgreSQL minor versions are now available. If you use maintenance windows, you might not yet have the minor version. In this case, you will see the new minor version once your maintenance update occurs. To find your maintenance window or manage maintenance updates, see Finding and setting maintenance windows.
- 9.6.20 is upgraded to 9.6.21.
- 10.15 is upgraded to 10.16.
- 11.10 is upgraded to 11.11.
- 12.5 is upgraded to 12.6.
- 13.1 is upgraded to 13.2.
For more information about the content of these minor versions, please see the PostgreSQL release notes.
April 06, 2021
Cloud SQL for PostgreSQL now lets you use IAM database authentication with the Cloud SQL Auth proxy. The Cloud SQL Auth proxy is able to request and refresh OAuth 2.0 access tokens, ensuring that long-lived processes or applications that rely on connection pooling can have stable connections. To learn more, see Using IAM database authentication with the Cloud SQL Auth proxy.
March 31, 2021
Cloud SQL for PostgreSQL flags are now generally available. See supported PostgreSQL flags for more information.
March 24, 2021
Support for europe-central2 (Warsaw ).
March 19, 2021
The following extensions in Cloud SQL for PostgreSQL are generally available:
- pg_partman. Enables you to create and manage time-based and serial-based table partition sets.
- pgTAP. Provides a unit testing framework for PostgreSQL, written in PL/pgSQL and PL/SQL.
February 24, 2021
Cloud SQL now offers faster maintenance, with average connectivity loss lasting 90 seconds or less on average. See more about maintenance timelines.
February 22, 2021
The following PostgreSQL minor versions are now available. If you use maintenance windows, you might not yet have the minor version. In this case, you will see the new minor version once your maintenance update occurs. To find your maintenance window or manage maintenance updates, see Finding and setting maintenance windows.
- PostgreSQL 9.6.19 is upgraded to 9.6.20.
- PostgreSQL 10.14 is upgraded to 10.15.
- PostgreSQL 11.9 is upgraded to 11.10.
- PostgreSQL 12.4 is upgraded to 12.5.
- PostgreSQL 13 is upgraded to 13.1.
February 10, 2021
The Cloud SQL Admin API v1beta4 is now generally available. The URL for the Admin API will continue to refer to v1beta4 for backward compatibility. To start using the Cloud SQL Admin API now, see Using the Cloud SQL Admin API.
January 28, 2021
Query Insights is now generally available. Query Insights helps you detect, diagnose, and prevent query performance problems for Cloud SQL databases. It provides self-service, intuitive monitoring, and diagnostic information that goes beyond detection to help you to identify the root cause of performance problems.
To learn more, see Improving query performance.
January 19, 2021
Database auditing in Cloud SQL for PostgreSQL is generally available, through the open-source pgAudit extension. Using this extension, you can selectively record and track SQL operations performed against a given database instance.
The pgAudit extension helps you configure many of the logs often required to comply with government, financial, and ISO certifications.
January 13, 2021
Cloud SQL now exposes the metric database/memory/total_usage. This metric provides visibility into the database working set (including buffer cache). You can find this metric in the Metrics explorer within the Monitoring dashboard.
For more information about database/memory/total_usage, see Cloud SQL Metrics.
December 21, 2020
IAM database authentication for Cloud SQL for PostgreSQL is now generally available. To get started using IAM database authentication, see the Overview of Cloud SQL IAM database authentication.
December 17, 2020
Cloud SQL has expanded support for PostgreSQL extensions. Three additional PostgreSQL extensions are now available:
- dblink
- ip4r
- prefix
For additional information, see PostgreSQL extensions.
The following PostgreSQL minor versions have been upgraded:
- PostgreSQL 9.6.18 is upgraded to 9.6.19.
- PostgreSQL 10.13 is upgraded to 10.14.
- PostgreSQL 11.8 is upgraded to 11.9.
- PostgreSQL 12.3 is upgraded to 12.4.
December 16, 2020
Cloud SQL for PostgreSQL now supports the effective_cache_size flag.
November 19, 2020
Cloud SQL for PostgreSQL now supports retention settings for automated backups. You can configure retention of your automated backups for shorter or longer periods (1 to 365 days). The default setting remains 7 days.
Cloud SQL for PostgreSQL now supports retention settings for point-in-time recovery. You have the option of retaining logs, used for point-in-time recovery, for shorter periods (1 to 7 days). The default setting is 7.
November 05, 2020
PostgreSQL version 13 is now generally available. To start using PostgreSQL 13, see Creating instances.
October 12, 2020
Cloud SQL for PostgreSQL now offers IAM database authentication to help you better monitor and manage access for users and service accounts to databases. This feature allows users and service accounts to use IAM credentials to log into PostgreSQL instances. To learn more about how IAM database authentication works, see the Overview of Cloud SQL IAM database authentication. To configure an instance, see Configuring instances for IAM database authentication. To create users or service accounts, see Creating and managing users that use IAM database authentication.
Cloud SQL now offers "deny maintenance periods". With deny maintenance periods, you can prevent automatic maintenance from occurring during a specific time period. For example, the end-of-year holiday season is a time of peak load that requires heightened focus on infrastructure stability for many retail businesses. By setting a deny maintenance period from mid-October to mid-January, these businesses can prevent planned upgrades from Cloud SQL during their busiest time of year.
Database auditing in Cloud SQL for PostgreSQL is available through the open-source pgAudit extension. Using this extension, you can selectively record and track SQL operations performed against a given database instance.
The pgAudit extension helps you configure many of the logs often required to comply with government, financial, and ISO certifications.
September 15, 2020
Cloud SQL now offers serverless export. With serverless export, Cloud SQL performs the export from a temporary instance. Offloading the export operation allows databases on the primary instance to continue to serve queries and perform other operations at the usual performance rate.
The following PostgreSQL minor versions have been upgraded:
- PostgreSQL 9.6.16 is upgraded to 9.6.18.
- PostgreSQL 10.11 is upgraded to 10.13.
- PostgreSQL 11.6 is upgraded to 11.8.
- PostgreSQL 12.1 is upgraded to 12.3.
July 09, 2020
Cloud SQL now supports point-in-time recovery (PITR) for PostgreSQL. Point-in-time recovery helps you recover an instance to a specific point in time. For example, if an error causes a loss of data, you can recover a database to its state before the error occurred.
June 23, 2020
Committed use discounts (CUDs) are now available to purchase for Cloud SQL. CUDs provide discounted prices in exchange for your commitment to use a minimum level of resources for a specified term. With committed use discounts for Cloud SQL, you can earn a deep discount off your cost of use in exchange for committing to continuously use database instances in a particular region for a 1- or 3-year term. See the documentation for more details.
June 08, 2020
Support for asia-southeast2 region (Jakarta).
May 21, 2020
PostgreSQL version 12 is now generally available. To start using PostgreSQL 12, see Creating instances.
May 15, 2020
PostgreSQL 9.6 minor version is upgraded to 9.6.16. PostgreSQL 10 minor version is upgraded to 10.11. PostgreSQL 11 minor version is upgraded to 11.6. PostgreSQL 12 minor version is upgraded to 12.1.
May 11, 2020
Cloud SQL has expanded support for PostgreSQL extensions. Eight additional PostgreSQL extensions are now available:
- pageinspect
- pgfincore
- pg_freespacemap
- pg_repack
- pg_visibility
- PL/Proxy
- postgres_fdw
- postgresql-hll
For information about these newly-added extensions, see PostgreSQL extensions.
April 20, 2020
Support for us-west4 region (Las Vegas).
March 27, 2020
PostgreSQL version 12 is now Beta. To start using PostgreSQL 12, see Creating instances.
PostgreSQL version 10 is now generally available. To start using PostgreSQL 10, see Creating instances.
March 24, 2020
Cloud SQL now supports 96-core machine types for MySQL, Postgres, and SQL Server instances. For pricing-related information, see the Pricing page.
March 16, 2020
Cloud SQL now supports read replicas in a different region than that of the primary instance, providing additional protection against regional outages and improving read performance by making replicas available closer to your application. To get started, see Cross-region replicas.
Cloud SQL instances using private IP are now accessible across regions, at the regular cross-region network egress cost.
February 24, 2020
Support for us-west3 region (Salt Lake City).
January 30, 2020
PostgreSQL version 10 is now Beta. To start using PostgreSQL 10, see Creating Instances.
January 24, 2020
Support for asia-northeast3 region (Seoul).
December 17, 2019
Cloud SQL now supports VPC Service Controls, which let you add a service perimeter around the Cloud SQL Admin API and host project for Cloud SQL instances to reduce the risk of data exfiltration. To learn more about using VPC Service Controls with Cloud SQL, see Configuring VPC Service Controls.
December 13, 2019
You can now use Cloud VPN with Cloud SQL. To get started, see Using a VPN with Cloud SQL.
Connection organization policies for Cloud SQL give you the ability to set policies that control access to and from Cloud SQL instances. To learn more about this feature, see Connection organization policies. To use this feature, see Setting organization policies for Cloud SQL.
December 10, 2019
Cloud SQL now offers notifications for upcoming maintenance. See the Overview of maintenance on Cloud SQL instances. To find out how to sign up for notifications and check your instances for upcoming maintenance, see Finding and setting maintenance windows.
November 25, 2019
Cloud SQL now supports Access Transparency. As part of Google's long-term commitment to security and transparency, you can use Access Transparency, which provides you with logs of actions that Google staff have taken when accessing your data. To learn more about Access Transparency, see the Overview of Access Transparency.
November 19, 2019
Cloud SQL now supports customer-managed encryption keys (CMEK). With CMEK, you can encrypt Cloud SQL instances using a key you manage. To learn more about CMEK, see the Overview of customer managed encryption keys (CMEK). To start using CMEK, see Using customer-managed encryption keys (CMEK).
September 27, 2019
PostgreSQL version 11 is now generally available. PostgreSQL 11 is the default version when creating new instances. To start using PostgreSQL 11, see Creating Instances.
June 25, 2019
This release increases the maximum data storage for instances of MySQL (MySQL Second Generation) and PostgreSQL. The maximum data storage is increased from 10,230 GB to 30,720 GB. For Cloud SQL storage limits, see Limits. You can limit your automatic storage increases; see Automatic storage increase limit.
May 24, 2019
Cloud SQL now allows you to specify a location for backups, and to restrict data to a single region. To learn about custom backup locations, see Custom backup locations. To learn how to set a custom location for a backup, see Setting and viewing a custom location for backups.
April 18, 2019
Support for asia-northeast2 region (Osaka, Japan).
April 09, 2019
Cloud SQL now supports PostgreSQL version 11.1 Beta. To start using PostgreSQL 11 Beta, see Creating Instances.
April 03, 2019
Support added for 122 MySQL flags and 96 PostgreSQL flags. See Supported PostgreSQL Flags and Supported MySQL Flags.
March 11, 2019
Support for europe-west6 region (Zürich, Switzerland).
February 13, 2019
Cloud SQL for PostgreSQL connection limits are now double when memory is 6 GiB or higher. See the connection limits table for details.
December 06, 2018
GA support for Private IP connectivity.
November 06, 2018
October 01, 2018
Support for asia-east2 region (Hong Kong).
September 01, 2018
Beta support for private IP (private services access) connectivity.
Proxy version 1.12 released.
August 01, 2018
PostGIS extension includes full support for JSON-C.
July 01, 2018
Support for us-west2 region (Los Angeles).
June 01, 2018
Support for connecting from Cloud Functions Beta.
Support for europe-north1 region (Finland).
Support for rotating SSL certificates.
May 01, 2018
Support for asia-southeast1 region (Singapore).
April 01, 2018
GA support for Cloud SQL for PostgreSQL.
March 01, 2018
Support for europe-west4 region (Netherlands).
February 01, 2018
Maximum concurrent connections to App Engine updated from 12 to 60.
January 01, 2018
MySQL 5.6 minor version upgraded to 5.6.36.
Support for northamerica-northeast1 region (Montréal).
Connection limits for PostgreSQL instances changed. Learn more.
November 01, 2017
Beta support for the high availability configuration and replication for PostgreSQL instances.
October 01, 2017
Support for asia-south1 region (Mumbai).
Proxy version 1.11 released.
September 01, 2017
Support for 64-core machine types for MySQL instances and 64 cores for PostgreSQL instances.
Support for southamerica-east1 region (São Paulo).
August 01, 2017
Support for europe-west3 region (Frankfurt).
June 01, 2017
Support for labels.
Proxy version 1.10 released.
Support for the JDBC Socket Library for PostgreSQL.
Support for australia-southeast1 region (Sydney).
Support for europe-west2 region (London).
Support for the following PostgreSQL extensions: btree-gin, btree-gist, chkpass, citext, cube, dict_int, dict_xsyn, earthdistance, intagg, intarray, isn, ltree, pgstattuple, pg_trgm, tablefunc, tsm_system_rows, tsm_system_time, unaccent, uuid-ossp.
May 01, 2017
GA support for Second Generation and PostgreSQL instances in version 157.0.0 of the gcloud command-line tool. The beta version is no longer required for these instances.
Support for us-west1 region (Oregon).
Support for us-east4 region (Northern Virginia).
April 01, 2017
Proxy version 1.09 released.
March 01, 2017
Cloud SQL for PostgreSQL Beta availability.
To provide feedback on the beta release, go to our Cloud SQL user forum.