AliPG kernel minor version releases (PostgreSQL 14-18)

Minor version

Description

20260830

Compatible with community PostgreSQL 15.18.

• New features

  • The auto_create_duckdb_table parameter of the rds_duckdb extension now supports the all, record, and none automatic table creation modes.

• Bug fixes

  Fixed known issues.

20260630

Compatible with community PostgreSQL 15.17.

• Bug fixes

  Fixed known issues.

20260530

Compatible with community PostgreSQL 15.17.

• New features

  None.

• Bug fixes

  Fixed known issues.

20260330

Based on community version 15.17.

• New features

  • The pgvector extension now supports the ivf-rabitq index.

• Bug fixes

  Resolves known issues.

20260228

Based on community version 15.17.

• Bug fixes

  Resolves known issues.

20260215

Based on community version 15.16.

• Bug fixes

  Resolves known issues.

20260130

Based on community version 15.15.

• New features

  • Adds the age extension 1.6.0.

• Bug fixes

  Resolves known issues.

20251130

Based on community version 15.14.

• New features

  • Adds the online partitioning (rds_online_migrate) extension V1.0.

  • Adds the clickhouse_fdw extension V1.4.

• Bug fixes

  Resolves known issues.

20250830

Based on community version 15.14.

• New features

  Adds the Online DDL (rds_online_ddl) extension 1.0.

• Bug fixes

  Resolves known issues.

20250630

Based on community version 15.13.

• New features

  • Adds the snowflake extension 2.2.

  • Adds the stored procedure debugger (pldebugger) extension 1.8.

• Bug fixes

  Resolves known issues.

20250430

Based on community version 15.12.

• New features

  Adds the AI (rds_ai) extension 1.0.0.

• Bug fixes

  • Fixes a security vulnerability in the scheduled task (pg_cron) extension and re-enables its creation.

  • Resolves other known issues.

20250228

Based on community version 15.12.

• New features

  • Upgrades the rds_ccl extension to 1.2, enabling configuration of the search_path parameter for query_id-based throttling.

  • Upgrades the rds_duckdb extension to 1.3, adding support for automatic incremental synchronization of columnar table data.

• Bug fixes

  Resolves known issues.

20241230

Based on community version 15.8.

• New features

  • Upgrades the pgvector extension to 0.8.0.

  • Upgrades the pg_hint_plan extension to 1.5.2.

  • Upgrades the rds_duckdb extension to 1.2, adding support for incremental DML synchronization.

  • Adds the automatic time column update feature.

• Bug fixes

  Resolves known issues.

20241030

Based on community version 15.8.

• New features

  • Adds the rds_duckdb extension 1.1.

  • Upgrades the GanosBase extension to 6.9. For more information, see Release notes for GanosBase.

• Bug fixes

  Resolves known issues.

20240830

Based on community version 15.8.

• New features

  • Adds the age extension 1.5.0.

  • Upgrades the wal2json extension to 2.6.

  • Upgrades the hll extension to 2.18.

  • Upgrades the pg_repack extension to 1.5.0.

  • Upgrades the hypopg extension to 1.4.1.

  • Upgrades the pgvector extension to 0.7.4.

  • Upgrades the pg_partman extension to 5.1.0.

  • Upgrades the encdb extension to 1.1.14.

• Bug fixes

  Resolves other known issues.

20240730

Based on community version 15.7.

• New features

  None.

• Bug fixes

  Resolves known issues.

20240530

Based on community version 15.6.

• New features

  • Adds the pg_proctab extension 0.0.10.

  • Upgrades the pgvector extension to 0.7.0.

• Bug fixes

  Resolves known issues.

20240229

Based on community version 15.6.

• New features

  • Adds the pg_squeeze extension 1.6.

  • Upgrades the pgvector extension to 0.6.0.

  • Upgrades the pglogical extension to 2.4.4.

  • Upgrades the mysql_fdw extension to 1.2.

  • Upgrades the orafce extension to 4.9.2.

  • Upgrades the pg_cron extension to 1.6.

  • Upgrades the pg_stat_kcache extension to 2.2.3.

  • Upgrades the pg_profile extension to 4.4.

  • Upgrades the pgl_ddl_deploy extension to 2.2.

  • Upgrades the pg_partman extension to 5.0.1.

  • Upgrades the postgis, postgis_sfcgal, postgis_tiger_geocoder, and postgis_topology extensions to 3.3.4.

  • Upgrades the GanosBase extension to 6.3. For more information, see Release notes for GanosBase.

• Bug fixes

  Resolves known issues.

20231230

Based on community version 15.5.

• New features

  • Adds the rds_embedding extension 1.0.

  • Upgrades the GanosBase extension to 6.0. For more information, see Release notes for GanosBase.

• Bug fixes

  Resolves known issues.

20231030

Based on community version 15.4.

• New features

  • The transparent data encryption (TDE) feature now supports global parameter settings to encrypt new tables and indexes by default.

• Bug fixes

  Upgrades the GanosBase extension to 5.9, which resolves known issues.

20230830

Based on community version 15.4.

• New features

  • Adds the cache eviction feature.

  • Adds the postgresql_anonymizer extension 1.1.0.

  • Upgrades the pgvector extension to 0.5.0, adding support for HNSW indexes, parallel index builds for IVFFlat, element-wise multiplication for vectors, L1 distance functions, and sum aggregation.

  • Upgrades the GanosBase extension to 5.8. For more information, see Release notes for GanosBase.

• Bug fixes

  Resolves known issues.

20230730

Based on community version 15.1.

• New features

  None.

• Bug fixes

  Resolves known issues.

20230630

Based on community version 15.1.

• New features

  The pg_jieba extension now allows you to configure the use of the default dictionary during searches.

• Bug fixes

  None.

20230530

Based on community version 15.1.

• New features

  • Adds the pg_partman extension 4.7.3.

  • Upgrades the pg_cron extension to 1.5.

  • Upgrades the GanosBase extension to 5.6. For more information, see Release notes for GanosBase.

• Bug fixes

  Fixes a connection failure between the profile and server databases when using the pg_profile extension.

20230430

Based on community version 15.1.

• New features

  • Adds support for ICU collations.

  • Adds the pgvector extension 0.4.1.

  • Upgrades the rds_ccl extension to 1.1.

  • Upgrades the GanosBase extension to 5.5. For more information, see Release notes for GanosBase.

• Bug fixes

  Fixes DROP DATABASE command failures that occurred when using both the pg_cron and pglogical extensions.

20230330

Based on community version 15.1.

• New features

  Adds the rds_ccl extension 1.0 for SQL throttling.

• Bug fixes

  • Fixes incorrect output locations for audit logs and slow query logs to ensure their collection.

  • Resolves other known issues.

20230228

Based on community version 15.1.

• New features

  • Adds the TimescaleDB extension 2.9.2.

  • Adds the pg_hint_plan extension 1.5.

  • Adds the ip4r extension 2.4.

  • Adds the pgl_ddl_deploy extension 2.1.

  • Upgrades the GanosBase extension to 5.4. For more information, see Release notes for GanosBase.

  • Upgrades the pgRouting extension to 3.4.2.

• Bug fixes

  None.

20221230

Based on community version 15.1.

• New features

  • Adds the PASE extension 0.0.1.

  • Upgrades the GanosBase extension to 5.3. For more information, see Release notes for GanosBase.

• Bug fixes

  None.

20221030

Based on community version 15.1.

Initial release.

• For supported features, see Feature overview.

• For information about supported extensions, see List of Extensions Supported by RDS for PostgreSQL.

Minor version

Description

20260830

Compatible with community PostgreSQL 14.23.

• New features

  • The auto_create_duckdb_table parameter of the rds_duckdb extension now supports the all, record, and none automatic table creation modes.

• Bug fixes

  Fixed known issues.

20260630

Compatible with community PostgreSQL 14.22.

• Bug fixes

  Fixed known issues.

20260530

Compatible with community PostgreSQL 14.22.

• New features

  • Now supports the pg_pathman extension (V1.5).

  • The wal2json extension now supports polar-include-unchanged-toast.

• Bug fixes

  Fixed known issues.

20260330

Compatible with community PostgreSQL 14.22.

• New features

  • The pgvector extension now supports ivf-rabitq indexes.

• Bug fixes

  Fixed known issues.

20260228

Compatible with community PostgreSQL 14.22.

• Bug fixes

  Fixed known issues.

20260215

Compatible with community PostgreSQL 14.21.

• Bug fixes

  Fixed known issues.

20260130

Compatible with community PostgreSQL 14.20.

• New features

  • Added the age extension, version 1.6.0.

• Bug fixes

  Fixed known issues.

20251130

Compatible with community PostgreSQL 14.19.

• New features

  • Added the online partitioning (rds_online_migrate) extension, version 1.0.

  • Added the clickhouse_fdw extension, version 1.4.

• Bug fixes

  Fixed known issues.

20250830

Compatible with community PostgreSQL 14.19.

• New features

  Added the Online DDL (rds_online_ddl) extension, version 1.0.

• Bug fixes

  Fixed known issues.

20250630

Compatible with community PostgreSQL 14.18.

• New features

  Added the pldebugger extension for debugging stored procedures, version 1.8.

• Bug fixes

  Fixed known issues.

20250430

Compatible with community PostgreSQL 14.17.

• New features

  Added the AI (rds_ai) extension, version 1.0.0.

• Bug fixes

  • Fixed a security vulnerability in the pg_cron extension and re-enabled its creation.

  • Fixed other known issues.

20250228

Compatible with community PostgreSQL 14.17.

• New features

  The rds_ccl extension has been upgraded to version 1.2, which allows you to configure the search_path parameter when using query_id-based SQL throttling.

• Bug fixes

  Fixed known issues.

20241230

Compatible with community PostgreSQL 14.13.

• New features

  • The pgvector extension has been upgraded to version 0.8.0.

  • The pg_hint_plan extension has been upgraded to version 1.4.3.

• Bug fixes

  Fixed known issues.

20241030

Compatible with community PostgreSQL 14.13.

• New features

  • Added the rds_duckdb extension, version 1.1.

  • The Ganos extension has been upgraded to version 6.9. For more information, see Release Notes for the Spatio-temporal Engine.

• Bug fixes

  Fixed known issues.

20240830

Compatible with community PostgreSQL 14.13.

• New features

  • Added the age extension, version 1.5.0.

  • The wal2json extension has been upgraded to version 2.6.

  • The hll extension has been upgraded to version 2.18.

  • The pg_repack extension has been upgraded to version 1.5.0.

  • The hypopg extension has been upgraded to version 1.4.1.

  • The pgvector extension has been upgraded to version 0.7.4.

  • The pg_partman extension has been upgraded to version 5.1.0.

  • The encdb extension has been upgraded to version 1.1.14.

• Bug fixes

  Fixed known issues.

20240730

Compatible with community PostgreSQL 14.12.

• New features

  None.

• Bug fixes

  Fixed known issues.

20240530

Compatible with community PostgreSQL 14.11.

• New features

  • Added the pg_proctab extension, version 0.0.10.

  • The pgvector extension has been upgraded to version 0.7.0.

• Bug fixes

  Fixed known issues.

20240229

Compatible with community PostgreSQL 14.11.

• New features

  • Added the pg_squeeze extension, version 1.6.

  • The pgvector extension has been upgraded to version 0.6.0.

  • The pglogical extension has been upgraded to version 2.4.4.

  • The mysql_fdw extension has been upgraded to version 1.2.

  • The orafce extension has been upgraded to version 4.9.2.

  • The pg_cron extension has been upgraded to version 1.6.

  • The pg_stat_kcache extension has been upgraded to version 2.2.3.

  • The pg_profile extension has been upgraded to version 4.4.

  • The pgl_ddl_deploy extension has been upgraded to version 2.2.

  • The pg_partman extension has been upgraded to version 5.0.1.

  • The PostGIS, postgis_sfcgal, postgis_tiger_geocoder, and postgis_topology extensions have been upgraded to version 3.3.4.

  • The Ganos extension has been upgraded to version 6.3. For more information, see Release Notes for the Spatio-temporal Engine.

• Bug fixes

  Fixed known issues.

20231230

Compatible with community PostgreSQL 14.10.

• New features

  • Added the rds_embedding extension, version 1.0.

  • The Ganos extension has been upgraded to version 6.0. For more information, see Release Notes for the Spatio-temporal Engine.

• Bug fixes

  Fixed known issues.

20231030

Compatible with community PostgreSQL 14.9.

• New features

  • TDE now supports global parameter settings, which enable you to encrypt new tables and indexes by default.

• Bug fixes

  The Ganos extension has been upgraded to version 5.9, fixing known issues.

20230830

Compatible with community PostgreSQL 14.9.

• New features

  • Added support for cache eviction.

  • Added the postgresql_anonymizer extension, version 1.1.0.

  • The pgvector extension has been upgraded to version 0.5.0. It now supports HNSW indexes, parallel index builds for IVFFlat, element-wise multiplication of vectors, L1 distance functions, and sum aggregation.

  • The Ganos extension has been upgraded to version 5.8. For more information, see Release Notes for the Spatio-temporal Engine.

• Bug fixes

  Fixed known issues.

20230630

Compatible with community PostgreSQL 14.6.

• New features

  The pg_jieba extension now allows you to configure whether to use the default dictionary during searches.

• Bug fixes

  None.

20230530

Compatible with community PostgreSQL 14.6.

• New features

  • Added the pg_partman extension, version 4.7.3.

  • The pg_cron extension has been upgraded to version 1.5.

  • The Ganos extension has been upgraded to version 5.6. For more information, see Release Notes for the Spatio-temporal Engine.

• Bug fixes

  Fixed an issue where a profile database failed to connect to a server database when the pg_profile extension was used.

20230430

Compatible with community PostgreSQL 14.6.

• New features

  • Added support for ICU collations.

  • Added the pgvector extension, version 0.4.1.

  • The rds_ccl extension has been upgraded to version 1.1.

  • The Ganos extension has been upgraded to version 5.5. For more information, see Release Notes for the Spatio-temporal Engine.

• Bug fixes

  Improved the performance of the pg_jieba extension and fixed an out-of-memory (OOM) issue that occurred when loading very large dictionaries.

20230330

Compatible with community PostgreSQL 14.6.

• New features

  • Added the rds_ccl extension, version 1.0, for SQL throttling.

  • The TimescaleDB extension has been upgraded to version 2.9.2.

• Bug fixes

  Fixed known issues.

20230228

Compatible with community PostgreSQL 14.6.

• New features

  • The Ganos extension has been upgraded to version 5.4. For more information, see Release Notes for the Spatio-temporal Engine.

  • Added the ip4r extension, version 2.4.

  • Added the pgl_ddl_deploy extension, version 2.1.

  • The pgRouting extension has been upgraded to version 3.4.2.

  • The pglogical extension has been upgraded to version 2.4.2.

• Bug fixes

  None.

20221230

Compatible with community PostgreSQL 14.6.

• New features

  • The Ganos extension has been upgraded to version 5.3. For more information, see Release Notes for the Spatio-temporal Engine.

  • Added the PASE extension, version 0.0.1.

  • The PostGIS extension has been upgraded to version 3.3.2.

  • The encdb extension has been upgraded to version 1.1.12.

• Bug fixes

  None.

20221030

Compatible with community PostgreSQL 14.5.

• New features

  • The Ganos extension has been upgraded to version 5.1. For more information, see Release Notes for the Spatio-temporal Engine.

  • Added support for table-level transparent data encryption (TDE).

  • Added the rds_tde_utils extension, version 1.0.

  • Added the pg_profile extension, version 4.1.

  • Added the pg_stat_kcache extension, version 2.2.1.

  • Added the mysql_fdw extension, version 1.1.

  • Added the pg_repack extension, version 1.4.7.

  • Added the zhparser extension, version 1.0.

  • Added the rum extension, version 1.3.

  • Added the plv8 extension, version 2.3.15.

  • Added the pg_hint_plan extension, version 1.4.0.

  • Added the tds_fdw extension, version 2.0.3.

• Bug fixes

  None.

20220830

Compatible with community PostgreSQL 14.4.

• New features

  • The encdb extension has been upgraded to version 1.1.1.

  • Added the encdb_btree extension, version 1.0.0, to accelerate ciphertext queries in fully encrypted databases.

  • Added the oss_fdw extension, version 1.1.

  • Added the TimescaleDB extension, version 2.5.0.

  • Optimized the memory usage of the index_adviser extension.

• Bug fixes

  Fixed an out-of-bounds memory access issue in the index_adviser extension that occurred during complex queries.

20220730

Compatible with community PostgreSQL 14.4.

• New features

  • The Ganos extension has been upgraded to version 4.9. For more information, see Release Notes for the Spatio-temporal Engine.

    • Added the ST_Intersection aggregate function to support aggregating arrays of Geometry objects.

    • Added the ST_AddZ function. This function supports an array of Z coordinates as a parameter to convert 2D/3DM Geometry objects into 3D/4D Geometry objects.

    • Enhanced the ST_SetValue function to support setting pixel values based on the spatial range of a specified geometry object.

    • Enhanced the ST_ExportTo function to support exporting Raster objects to COG files.

    • Enhanced the ST_CreateRast function to support converting multiple records or arrays of regular grid points into raster objects.

    • Enhanced the ST_Split function to support splitting by time (with a specified start time) or by the sequence number of trajectory points.

    • Enhanced the ST_Union function to support batch execution based on memory usage, which prevents OOM errors when large volumes of data are processed.

    • Added HDFS support for raster data.

  • Added the pg_jieba Chinese word segmentation extension. It supports custom dictionaries, dictionary switching, and displaying segmentation results based on the offset of each field.

• Bug fixes

  Fixed an issue where the index_adviser extension crashed if all recommended indexes already existed.

20220630

Compatible with community PostgreSQL 14.4.

• New features

  The Ganos extension has been upgraded to version 4.7. For more information, see Release Notes for the Spatio-temporal Engine.

  • Enhanced the ST_makeTrajectory function to support converting table rows into trajectories.

  • Added the ST_AsTable function to support converting trajectories into table types.

• Bug fixes

  Fixed the silent corruption of indexes caused by "CREATE INDEX CONCURRENTLY" / "REINDEX CONCURRENTLY".

20220228

Compatible with community PostgreSQL 14.1.

• New features

  • Added the sequential-uuids extension, version 1.0.2.

  • The encdb extension has been upgraded to version 1.1.9.

  • The Ganos extension has been upgraded to version 4.6. For more information, see Release Notes for the Spatio-temporal Engine.

    • Added support for accessing raster data from self-managed MinIO servers. For more information, see Object storage paths.

    • Added the ST_PointValues raster function, which returns the pixel values of all bands.

  • Standard user accounts can now run the LOAD command to load the index_adviser and pg_hint_plan extensions.

  • Privileged accounts can now configure the BYPASSRLS parameter when they run the CREATE ROLE command.

• Bug fixes

  Fixed an issue where parameter values were missing from slow query logs.

20220130

Compatible with community PostgreSQL 14.1.

New features

• Added the index_adviser extension, version 2.0.

• Added the hypopg extension, version 1.3.1.

• The Ganos extension has been upgraded to version 4.5. For more information, see Release Notes for the Spatio-temporal Engine.

• The encdb extension has been upgraded to version 1.1.7.

• The pg_cron extension has been upgraded to version 1.1.

• The roaringbitmap extension has been upgraded to version 0.5.

20211130

Compatible with community PostgreSQL 14.1.

Initial release.

• For supported features, see Feature Overview.

• For supported extensions, see Extensions supported by ApsaraDB RDS for PostgreSQL.