Release notes

This page documents production updates to Cloud SQL. You can check this page for announcements about new or updated features, bug fixes, known issues, and deprecated functionality.

You can see the latest product updates for all of Google Cloud on the Google Cloud page, or browse and filter all release notes in the Google Cloud Console.

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

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

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 Query Insights. To get started now, 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

Support for CSV format for PostgreSQL instance imports and exports.

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).

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

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 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.