Yandex Managed Service for PostgreSQL release notes

July 2025July 2025

Now you can upgrade clusters to PostgreSQL version 17 using standard tools without Yandex Data Transfer.

May 2025May 2025

Now you can encrypt storage disks with a custom KMS key when creating a cluster and restoring it from a backup.

April 2025April 2025

Added integration with Connection Manager. Now, a connection in Connection Manager is automatically created for all new clusters.

March 2025March 2025

• Now you can use backup policies.
• Added the Technical maintenance section to the management console.

February 2025February 2025

Now you can upgrade clusters to PostgreSQL version 16 using standard tools without Yandex Data Transfer.

January 2025January 2025

logerrors is now a system extension enabled by default in new clusters.

October 2024October 2024

• Now you can specify a retention period for your automatic backups.
• Added the mdb_superuser role for users who are not database owners but need to manage privileges as owners.

September 2024September 2024

• Added support for PostgreSQL version 17. Learn how to update a cluster in PostgreSQL version upgrade.
• Added support for the postgresql_anonymizer (anon) extension for data anonymization.

May 2024May 2024

Users with the mdb_admin role can now use the pg_stat_reset_single_table_counters() and pg_stat_reset_single_function_counters() functions.

March 2024March 2024

• Now you can configure incremental auto increase of the cluster storage size. Users can set the disk storage usage threshold and the maximum disk size. Upon reaching the threshold, the disk size will automatically increase in fixed increments up to its maximum.

• Now you can upgrade PostgreSQL for 1C to versions 13, 14, and 15.

• Installed the updates from versions 16.2, 15.6, 14.11, 13.14, and 12.18.

• Expanded the permissions for users with the mdb_admin role. Now they can:

  • Grant additional users permissions to use the pg_cron extension.
  • Reset statistics using the pg_stat_reset_shared() function.
  • Terminate the autovacuum sessions.

• Now you can audit Managed Service for PostgreSQL cluster connection events and pgaudit events in Yandex Audit Trails.

Q4 2023Q4 2023

Added support for PostgreSQL version 16.

Key changes in the new version:

• Added the pg_stat_io view for input/output monitoring.
• Added parallel implementation of a hash full join and a hash right join.
• Improved the performance of the vacuum freeze operation.
• Added the logical replication setting from a replica.
• New version 16 clusters use ICU locales instead of libc.

For information on how to update a cluster, see PostgreSQL version upgrade.

For more information about the updates in PostgreSQL version 16, see this PostgreSQL article.

Q3 2023Q3 2023

PostgreSQL 11 is no longer supported. Starting August 14, you can no longer create new clusters of this version, and the existing clusters were automatically updated on September 12 during the maintenance window.

Q2 2023Q2 2023

• You can now export raw data on performance diagnostics using the PerformanceDiagnosticsService/ListRawSessionStates and PerformanceDiagnosticsService/ListRawStatements gRPC API calls.
• Added the Session duration timeout setting that controls the lifetime of the longest active session or transaction. The default value is 12 hours.

Q4 2022Q4 2022

• Added support for PostgreSQL version 15.

  Key changes in the new version:

  • Added support for the SQL MERGE command that enables performing the INSERT, UPDATE, or DELETE action depending on the conditions.
  • You can now specify column lists and row filter conditions. This allows selective publication of table contents with logical replication.
  • You can now specify ICU for a database by default.
  • Improved performance, in particular, for in-memory and on-disk sorting.

  For information on how to update a cluster, see PostgreSQL version upgrade.

  For more information about the updates in PostgreSQL version 15, see this PostgreSQL article.

• Added support for the pgaudit and pg_prewarm extensions.

• You can now restore a cluster from a backup in a different folder using any interface.

Q3 2022Q3 2022

• Added the Inode usage, Memory usage, and Free space charts to the cluster monitoring tab.
• PostgreSQL 10 is no longer supported. Starting August 15, you can no longer create new clusters of this version, and an automatic cluster update is scheduled from September 1 as part of the maintenance window. To learn how to update a cluster on your own, see PostgreSQL version upgrade.
• You can now create a database from a template with the CLI and Terraform.
• Added support for the pg_cron extension.
• Installed the version 14.4 update with index corruption issues fixed.

Q2 2022Q2 2022

• Installed the updates from versions 14.3, 13.7, 12.11, 11.16, and 10.21.
• You can now create a cluster of versions 13 and 14 for 1C.
• Added the ability to upgrade from version 13 to 14.
• Added the mdb_monitor role that includes the privileges of the pg_monitor system role. For more information, see Assigning roles.
• Removed the database and user sections in the Terraform configuration files and added the yandex_mdb_postgresql_database and yandex_mdb_postgresql_user resources instead.
• Odyssey 1.3 is now available with support for prepared statements in transaction pooling mode. You can use the pool_reserve_prepared_statement setting to activate a pool of prepared database statements where Odyssey will prepare session statements as needed.
• Added the max_logical_replication_workers and max_replication_slots settings.

Q1 2022Q1 2022

• Added the pgcompacttable, clickhouse_fdw, and orafce extensions.
• You can now create a new database from a template.