AlloyDB for PostgreSQL release notes

This page documents production updates to AlloyDB for PostgreSQL. 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, browse and filter all release notes in the Google Cloud console, or 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/alloydb-release-notes.xml

February 29, 2024

AlloyDB AI is now generally available (GA).

AlloyDB Omni version 15.5.0 is now available. This version includes the following features and changes:

  • When installing AlloyDB Omni using its command-line tool, you can now specify the TCP port that the instance accepts connections on.
  • Automated failover for highly available (HA) Kubernetes-based clusters is available in Preview.
  • The following extensions are updated:
    • Updated pg_cron to version 1.6.
    • Updated pg_repack to version 1.5.0.
    • Updated pgfincore to version 1.3.1.
    • Updated pglogical to version 2.4.4.
    • Updated pgvector to version 0.5.1.
  • The following extensions are now included:
    • Added autoinc version 1.0.
    • Added insert_username version 1.0.
    • Added moddatetime version 1.0.
    • Added tcn version 1.0.
  • Updated core PostgreSQL compatibility to version 15.5.
  • Applied security fix CVE-2024-0985 from PostgreSQL.
  • Various bug fixes and performance improvements.

The return value of the embedding() function of google_ml_integration has changed. The embedding() function now returns an array of REAL values, and not a VECTOR value. This allows you to install and use the extension without the requirement of installing pgvector as well.

If you wrote application code that uses embedding() during the Preview of AlloyDB AI, then you might need to update it to add explicit casting from the REAL[] data type to the VECTOR data type. For more information, see Work with vector embeddings.

A revised quickstart helps you install and run AlloyDB Omni on a Debian or Ubuntu system using a handful of commands.

February 28, 2024

AlloyDB now supports the use of Google Cloud tags on cluster and backup resources. Tags are key-value pairs you can apply to your resources for granular IAM permissions. To learn more, see Organize resources using tags. To use tags now, see Attach and manage tags on AlloyDB resources.

February 27, 2024

You can now use Automatic IAM Authentication with the AlloyDB Language Connectors (Preview) to connect to your cluster. For more information, see Connect using the AlloyDB Language Connectors.

February 20, 2024

You can now configure instances to use 128 vCPUs and 864 GB of RAM per node.

February 09, 2024

You can now use public IP with the AlloyDB Language Connectors (Preview) to connect to your cluster. For more information, see Connect using the AlloyDB Language Connectors.

January 29, 2024

AlloyDB Public IP is now available in Preview. You can configure an AlloyDB instance to have a public IP address and accept connections from authorized external IP addresses.

Fixed the issue causing failed connections to certain AlloyDB instances when using Auth Proxy version 1.5.0.

January 25, 2024

AlloyDB Language Connectors are now available in Preview. These language connectors are libraries that provide automated mutual TLS connections, IAM-based authorization, and Automated IAM Authentication when connecting to an AlloyDB instance. For more information about language connectors, see AlloyDB Language Connectors overview.

January 24, 2024

AlloyDB support for Cloud regions in the events timeline is now Generally available.

January 22, 2024

AlloyDB now supports cross-project restoration. You can restore an AlloyDB cluster to a new cluster in a different Google Cloud Project.

January 19, 2024

AlloyDB database server compatibility with PostgreSQL version 15 is now generally available (GA). You can create or upgrade a cluster with PostgreSQL 15 compatibility.

December 20, 2023

AlloyDB Omni version 15.4.0 is now available. This version includes the following changes:

  • pgvector is updated to version 0.5.0
  • PostgreSQL is updated to version 15.4

The AlloyDB Omni Kubernetes Operator version 0.3.0 is now available in Preview, and includes bug fixes and improvements to the operator. For more information about upgrading AlloyDB using the Kubernetes operator, see Upgrade AlloyDB Omni.

December 18, 2023

Automated and continuous backups are now incremental backups. This allows AlloyDB to protect your data using smaller files rather than full backups, reducing your storage costs, and improving the backup speed.

December 15, 2023

AlloyDB for PostgreSQL now lets you monitor your AlloyDB instances using the AlloyDB System Insights dashboard or by using the Cloud Monitoring dashboard. You can also view metrics on the AlloyDB cluster Overview page.

December 14, 2023

AlloyDB now supports up to 64TiB storage per cluster in the following regions:

  • us-west1
  • us-central1
  • us-east1
  • us-east4
  • europe-west1
  • asia-east1
  • asia-southwest1

December 11, 2023

Terraform support for AlloyDB is now generally available (GA).

November 28, 2023

The AlloyDB columnar engine now supports columns with the array data type.

November 22, 2023

The following issue was fixed on January 29, 2024.

Version 1.5.0 of the AlloyDB Auth Proxy client might fail to connect to AlloyDB instances created before mid-November, 2023.

To mitigate this issue, take either one of the following steps:

  • Use version 1.4.1 of the AlloyDB Auth Proxy client. You can download this version by following the instructions on Download the Auth Proxy client, replacing 1.5.0 or latest in the commands with 1.4.1.

  • Update any database flag on the affected instance. We recommend using the Google Cloud console to set and then clear a flag that doesn't require the instance to restart, such as autovacuum. For a full list of flags, see Supported database flags.

November 15, 2023

IAM authentication for AlloyDB is generally available (GA).

You can now restrict an OAuth 2.0 access token so that it works only for AlloyDB authentication.

You can now configure the AlloyDB Auth Proxy to automatically authenticate IAM-based database logins. This works only with the IAM account that you use to run the proxy client.

AlloyDB Omni version 15.2.2 is available. This version resolves the previous version's issue with incremental backups, and contains various other bug fixes and improvements. For more information about upgrading AlloyDB Omni, see Upgrade AlloyDB Omni.

The AlloyDB Omni Kubernetes Operator version 0.2.0 is available in Preview. This update adds support for AlloyDB Omni version 15.2.2, and includes various bug fixes and improvements. For more information about upgrading AlloyDB using the Kubernetes operator, see Upgrade AlloyDB Omni.

November 08, 2023

The extension pgvector is updated to version 0.5.0.

The extension oracle_fdw is added to the extensions supported by AlloyDB. The extension provides a foreign data wrapper for accessing Oracle databases.

October 11, 2023

AlloyDB Omni is now generally available (GA).

In AlloyDB Omni version 15.2.1 and earlier, after a failover, when you promote a standby instance, incremental backups from the newly promoted instance might conflict with the existing backup files, and the backups might fail.

As a workaround, move the conflicting files into a separate directory.

The AlloyDB Omni Kubernetes Operator is now available in Preview. This extension to the Kubernetes API lets you deploy and manage AlloyDB Omni on a Kubernetes cluster.

September 28, 2023

AlloyDB secondary clusters now support read pool instances.

September 21, 2023

AlloyDB now offers basic instances, which are primary instances containing only one node, in one zone. Basic instances provide a lower-cost alternative to highly available instances, and are appropriate for use in non-production environments that don't require high availability.

Database server compatibility with PostgreSQL version 15 is now available in Preview. You can create a cluster with PostgreSQL 15 compatibility.

September 15, 2023

Maintenance operations on highly available primary instances now occur with less than one second of downtime for most workloads.

AlloyDB for PostgreSQL is now available in the following regions:

  • europe-west12 (Turin)
  • me-central1 (Doha)

For more information, see AlloyDB Locations.

September 13, 2023

AlloyDB now lets you use and manage data-encryption keys residing outside of Google Cloud using Cloud External Key Manager.

September 08, 2023

When creating an AlloyDB cluster, you can now specify an IP range for private services access. This is optional; if you do not specify an IP range, then AlloyDB selects one for you.

September 06, 2023

Updated the PostgreSQL-compatible server running on AlloyDB instances to version 14.7.

Updated the following extensions related to the PostGIS extension to version 3.2.3:

  • postgis
  • postgis_raster
  • postgis_sfcgal
  • postgis_tiger_geocoder
  • postgis_topology
  • address_standardizer
  • address_standardizer_data_us

The following extensions are updated:

  • Updated pg_hint_plan to version 1.4.1.
  • Updated pg_repack to version 1.4.8.
  • Updated pg_partman to version 4.7.3.
  • Updated postgresql-hll to version 2.17.
  • Updated pg_cron to version 1.5.
  • Updated pg_hint_plan to version 1.4.1.
  • Updated pg_repack to version 1.4.8.
  • Updated pg_partman to version 4.7.3.
  • Updated postgresql-hll to version 2.17.
  • Updated pg_cron to version 1.5.

August 29, 2023

AlloyDB AI, a suite of features for building generative AI applications, is now available with both AlloyDB and AlloyDB Omni. These features include the following:

  • The AlloyDB machine learning (ML) extension introduces an embedding SQL function. It lets you create vector embeddings from text using ML models. You can store these embeddings as vector data, and apply them as input to pgvector functions.

  • AlloyDB support for the pgvector extension brings performance enhancements for vector queries that run up to ten times faster than standard PostgreSQL, including an optimization that lets you create indexes of stored vector data using scalar quantization.

AlloyDB Omni version 15.2.0 is available in Preview. This version includes the following:

A separate Technology Preview edition of AlloyDB Omni is available. It lets you experiment with AlloyDB AI functionality using two included machine learning models trained on Google News text.

In AlloyDB Omni version 15.2.0, using the COPY function with the FREEZE option is disabled, due to a potential performance issue when loading large datasets.

August 22, 2023

You can now improve connection security by enforcing applications to connect to AlloyDB instances through AlloyDB connectors, such as the Auth Proxy.

You can now configure SSL enforcement mode to ensure that all database connections to an instance use SSL encryption.

August 16, 2023

Instance machine-type configuration has added an option for 96 vCPUs and 768 GB of RAM per node.

AlloyDB now offers committed use discounts (CUDs) that provide 25% or 52% discount on AlloyDB's compute resources in exchange for your commitment, and you can continuously use them for one- or three-year terms, respectively.

August 08, 2023

AlloyDB Omni version alloydb-omni-0.3.0-preview-postgresql-15.2 is available. This version introduces PostgreSQL 15, and applies various bug fixes and query performance improvements.

July 28, 2023

Cloud Asset Inventory support for AlloyDB is generally available (GA).

July 18, 2023

AlloyDB support for Data Residency is generally available (GA).

AlloyDB now supports setting up resource locations policies that can be used to constrain the location of new in-scope resources.

July 05, 2023

June 30, 2023

Vectorized join is available in Preview. Part of the AlloyDB columnar engine, vectorized join can improve the performance of joins by applying vectorized processing to qualifying queries.

Fault injection lets you test the resilience of a cluster's primary instance by simulating a sudden outage of its active node. This triggers the AlloyDB high availability feature that automatically promotes the instance's standby node to become the new active node.

June 27, 2023

IAM authentication for AlloyDB is available in Preview. You can add a role to Identity and Access Management (IAM) user or service accounts that lets them log into AlloyDB instances as database users.

The columnar engine now supports columns with the following data types:

  • boolean
  • bytea
  • enum
  • uuid

June 21, 2023

AlloyDB cross-region replication is generally available (GA).

June 20, 2023

The extension anon has been added to extensions supported by AlloyDB.

June 16, 2023

AlloyDB for PostgreSQL is now available in europe-west9 (Paris). For more information, see AlloyDB Locations.

June 12, 2023

You can increase your quotas by submitting a request in the Quotas page.

You can now manage the storage quota for clusters through the Quotas page.

June 05, 2023

AlloyDB for PostgreSQL is now available in the following regions:

  • us-east5 (Columbus)
  • us-south1 (Dallas)

For more information, see AlloyDB Locations.

June 01, 2023

Continuous backup and recovery is generally available (GA).

May 17, 2023

The AlloyDB FORCE_APPLY update policy is available in Preview. Use this policy to modify database flags and apply updates faster (within 1-2 minutes) to an instance.

May 12, 2023

The AlloyDB admin API now includes user-management methods. These let you use the gcloud command-line tool to manage the user roles of your AlloyDB clusters, in addition to the PostgreSQL functions already supported.

May 11, 2023

The storage per cluster limit has increased to 32 TiB.

May 10, 2023

The columnar engine now supports columns with json and jsonb data types.

May 09, 2023

AlloyDB for PostgreSQL is now available in the following regions:

  • asia-south2 (Delhi)
  • europe-southwest1 (Madrid)
  • europe-west4 (Netherlands)
  • europe-west8 (Milan)
  • me-west1 (Tel Aviv)
  • northamerica-northeast1 (Montreal)
  • northamerica-northeast2 (Toronto)
  • southamerica-east1 (Brazil)
  • southamerica-west1 (Santiago)

For more information, see AlloyDB Locations.

May 08, 2023

The AlloyDB index advisor is now generally available (GA).

The extensions pgtt and rdkit have been added to AlloyDB's supported extensions.

May 05, 2023

AlloyDB Omni version alloydb-omni-0.2.0-preview-postgresql-14.4 is available. This version reduces the memory requirement of AlloyDB Omni to 2 GB of RAM, and applies various bug fixes and query performance improvements.

April 24, 2023

Three metrics tracking node health are available in Preview. These can help you monitor the activity of individual read pool nodes, and investigate and troubleshoot issues with read pool queries.

April 06, 2023

AlloyDB for PostgreSQL is available in us-west2 (Los Angeles). For more information, see AlloyDB locations.

March 29, 2023

AlloyDB Omni is available in Preview. AlloyDB Omni is a downloadable edition of AlloyDB for PostgreSQL that lets you run a containerized AlloyDB database engine in your own computing environment.

March 06, 2023

Cloud Client libraries for the AlloyDB Admin API are in Preview. Supported languages include C++, C#, Go, and Java.

February 27, 2023

AlloyDB for PostgreSQL is available in the following regions:

  • asia-east1 (Taiwan)
  • asia-east2 (Hong Kong)
  • asia-northeast2 (Osaka)
  • asia-northeast3 (Seoul)
  • asia-south1 (Mumbai)
  • asia-southeast2 (Jakarta)
  • australia-southeast1 (Sydney)
  • australia-southeast2 (Melbourne)
  • europe-central2 (Warsaw)
  • europe-north1 (Finland)
  • europe-west2 (London)
  • europe-west6 (Zurich)
  • us-east1 (South Carolina)
  • us-east4 (Northern Virginia)
  • us-west1 (Oregon)
  • us-west3 (Salt Lake City)

For more information, see AlloyDB Locations.

February 16, 2023

Continuous backup and recovery is in Preview. This feature protects your clusters from data-loss events by letting you recover their data from any moment within a configurable window.

December 13, 2022

AlloyDB for PostgreSQL is generally available (GA).

December 12, 2022

The AlloyDB index advisor helps you optimize your databases by observing the queries your databases handle, and then recommending new indexes based on these observations.

December 08, 2022

AlloyDB cross-region replication replicates your primary cluster's data and resources. It makes the data and resources available in different regions, allowing disaster recovery in the event of an outage in the primary region.

December 01, 2022

The AlloyDB Clusters page of the Google Cloud console displays summary cards and a resource table that provide an overview on the overall health of your databases. This helps you monitor the real-time performance of your database fleet.

September 15, 2022

Datastream, Google Cloud's change data capture (CDC) and replication service, supports PostgreSQL for source databases. This means that you can use an AlloyDB database as a Datastream source.

Google Cloud Database Migration Service has added support for AlloyDB. This service can make it easier to migrate your existing PostgreSQL data and workloads to an AlloyDB cluster.

August 25, 2022

AlloyDB supports customer-managed encryption keys (CMEK), an alternative to its default Google-managed encryption. CMEK is especially useful for AlloyDB users who need to manage their own data encryption keys in order to satisfy specific compliance or regulatory requirements.

August 24, 2022

You can view which zones host a primary instance's active or standby VMs.

July 12, 2022

When creating a primary or read-pool instance, or scaling either one, you can choose a machine size as small as 2 vCPUs with 16 GB of RAM.

June 28, 2022

AlloyDB's Frequently asked questions page addresses common questions received by the AlloyDB support team during the product's public preview.

May 31, 2022

VPC Service Controls, a Cloud-wide feature that helps mitigate the risk of data exfiltration, is available with AlloyDB.

May 11, 2022

AlloyDB for PostgreSQL is available in Preview.