Release notes for AliPG kernel versions (PostgreSQL 14-17) - ApsaraDB RDS

This topic describes the release notes for AliPG kernel versions for RDS PostgreSQL 14 to 17.

Important

If you want to use the features that are provided by a later minor engine version, you must update the minor engine version of your ApsaraDB RDS instance. For more information, see View and update the minor engine version.
For the release notes for AliPG of earlier PostgreSQL versions, see Release notes for AliPG (PostgreSQL 9.4~13).

PostgreSQL 17

Version	Description
20250430	PostgreSQL 17.4 is supported. New features The following extensions are supported: AI (rds_ai) (version 1.0.0), RUM (version 1.3), pg_cron (version 1.6), and pg_partman (version 5.2.4). For more information, see Supported extensions. Bug fixes Known issues are fixed.
20250228	PostgreSQL 17.4 is supported. New features The rds_ccl extension is updated to version 1.2. The search_path parameter can be configured when you perform SQL throttling based on the specified query_id value. Bug fixes Known issues are fixed.
20241230	PostgreSQL 17.0 is supported. New features Version 1.0.0 of pgsql-gzip is supported. The pgvector extension is updated to version 0.8.0. The automatic time column update feature is supported. For more information, see Automatic time column update. Bug fixes Known issues are fixed.
20241030	PostgreSQL 17.0 is supported. New features Version 7.0 of GanosBase extensions are supported. For more information, see Release notes for GanosBase. The following extensions are supported: rds_duckdb (version 1.1), smlar (version 1.0), pglogical (version 2.4.5), mysql_fdw (version 2.9.2), pgaudit (version 17.0), pg_repack (version 1.5.1), pg_wait_sampling (version 1.1), timescaledb (version 2.17.0), zhparser (version 1.0), pg_hint_plan (version 1.7.0), tds_fdw (version 2.0.4), ip4r (version 2.4), pg_squeeze (version 1.7), hypopg (version 1.4.1), roaringbitmap (version 0.5.4), rds_embedding (version 1.0), sequential-uuids (version 1.0.2), pg_jieba (version 1.2.0), pg_stat_kcache (version 2.3.0), postgresql_anonymizer (version 1.1.0), pg_proctab (version 0.0.10), postgis (version 3.3.7), address_standardizer (version 3.3.7), address_standardizer_data_us (version 3.3.7), postgis_sfcgal (version 3.3.7), postgis_tiger_geocoder (version 3.3.7), postgis_topology (version 3.3.7), pgrouting (version 3.4.2), pgvector (version 0.7.4). For more information, see Supported extensions. Bug fixes Known issues are fixed.
20240930	PostgreSQL 17.0 is supported. This is the initial release. For more information about the supported features, see Features. For more information about the supported extensions, see Supported extensions.

PostgreSQL 16

Version	Description
20250430	PostgreSQL 16.8 is supported. New features None. Bug fixes The security vulnerability in the pg_cron extension is fixed, and the extension is now supported for new installations. Other known issues are fixed.
20250228	PostgreSQL 16.8 is supported. New features Version 1.0 of rds_encdb is supported. Important When you enable the column encryption feature, the system automatically installs the rds_encdb extension in the target database. Currently, manual direct installation of this extension in the target database is not supported. If you need to perform self-installation, please contact us. The rds_ccl extension is updated to version 1.2. The search_path parameter can be configured when you perform SQL throttling based on the specified query_id value. Bug fixes Known issues are fixed.
20241230	PostgreSQL 16.4 is supported. New features Version 1.0.0 of AI (rds_ai) is supported. Version 1.6 of pgsql-http is supported. Version 1.0.0 of pgsql-gzip is supported. The pgvector extension is updated to version 0.8.0. The pg_hint_plan extension is updated to version 1.6.1. The rds_duckdb extension is updated to version 1.2 and supports the incremental synchronization of DML operations. The automatic time column update feature is supported. For more information, see Automatic time column update. Bug fixes Known issues are fixed.
20241030	PostgreSQL 16.4 is supported. New features The rds_duckdb extension is updated to version 1.1. The GanosBase extensions are updated to version 6.9. For more information, see Release notes for GanosBase. Bug fixes Known issues are fixed.
20240830	PostgreSQL 16.4 is supported. New features Version 1.5.0 of age is supported. (Public preview) Version 1.0 of rds_duckdb is supported. Version 1.0 of rds_embedding is supported. Version 2.6 of wal2json is supported. Version 1.4.1 of hypopg is supported. Version 1.2 of pg_bigm is supported. Version 0.5.4 of roaringbitmap is supported. The pg_repack extension is updated to version 1.5.0. The pgvector extension is updated to version 0.7.4. The pg_partman extension is updated to version 5.1.0. The encdb extension is updated to version 1.1.14. Bug fixes Other known issues are fixed.
20240730	PostgreSQL 16.3 is supported. New features None. Bug fixes Known issues are fixed.
20240530	PostgreSQL 16.2 is supported. New features Version 0.0.10 of pg_proctab is supported. The pgvector extension is updated to version 0.7.0. Bug fixes Known issues are fixed.
20240229	PostgreSQL 16.2 is supported. New features Version 1.6 of pg_squeeze is supported. The timescaledb extension is updated to version 2.14.2. The pgvector extension is updated to version 0.6.0. The orafce extension is updated to version 4.9.2. The pg_stat_kcache extension is updated to version 2.2.3. The pg_profile extension is updated to version 4.4. The pg_partman extension is updated to version 5.0.1. The GanosBase extensions are updated to version 6.3. For more information, see Release notes for GanosBase. Bug fixes Known issues are fixed.
20231230	PostgreSQL 16.1 is supported. Bug fixes Known issues are fixed.
20231030	PostgreSQL 16.0 is supported. This is the initial release. For more information about the supported features, see Features. For more information about the supported extensions, see Supported extensions.

PostgreSQL 15

Version	Description
20250430	PostgreSQL 15.12 is supported. New features Version 1.0.0 of AI (rds_ai) is supported. Bug fixes The security vulnerability in the pg_cron extension is fixed, and the extension is now supported for new installations. Other known issues are fixed.
20250228	PostgreSQL 15.12 is supported. New features The rds_ccl extension is updated to version 1.2. The search_path parameter can be configured when you perform SQL throttling based on the specified query_id value. The rds_duckdb extension is updated to version 1.3 and supports the automatic incremental synchronization of columnar table data. Bug fixes Known issues are fixed.
20241230	PostgreSQL 15.8 is supported. New features The pgvector extension is updated to version 0.8.0. The pg_hint_plan extension is updated to version 1.5.2. The rds_duckdb extension is updated to version 1.2 and supports the incremental synchronization of DML operations. The automatic time column update feature is supported. For more information, see Automatic time column update. Bug fixes Known issues are fixed.
20241030	PostgreSQL 15.8 is supported. New features Version 1.1 of rds_duckdb is supported. The GanosBase extensions are updated to version 6.9. For more information, see Release notes for GanosBase. Bug fixes Known issues are fixed.
20240830	PostgreSQL 15.8 is supported. New features Version 1.5.0 of age is supported. The wal2json extension is updated to version 2.6. The hll extension is updated to version 2.18. The pg_repack extension is updated to version 1.5.0. The hypopg extension is updated to version 1.4.1. The pgvector extension is updated to version 0.7.4. The pg_partman extension is updated to version 5.1.0. The encdb extension is updated to version 1.1.14. Bug fixes Other known issues are fixed.
20240730	PostgreSQL 15.7 is supported. New features None. Bug fixes Known issues are fixed.
20240530	PostgreSQL 15.6 is supported. New features Version 0.0.10 of pg_proctab is supported. The pgvector extension is updated to version 0.7.0. Bug fixes Known issues are fixed.
20240229	PostgreSQL 15.6 is supported. New features Version 1.6 of pg_squeeze is supported. The timescaledb extension is updated to version 2.14.2. The pgvector extension is updated to version 0.6.0. The pglogical extension is updated to version 2.4.4. The mysql_fdw extension is updated to version 1.2. The orafce extension is updated to version 4.9.2. The pg_cron extension is updated to version 1.6. The pg_stat_kcache extension is updated to version 2.2.3. The pg_profile extension is updated to version 4.4. The pgl_ddl_deploy extension is updated to version 2.2. The pg_partman extension is updated to version 5.0.1. The postgis, postgis_sfcgal, postgis_tiger_geocoder, and postgis_topology extensions are updated to version 3.3.4. The GanosBase extensions are updated to version 6.3. For more information, see Release notes for GanosBase. Bug fixes Known issues are fixed.
20231230	PostgreSQL 15.5 is supported. New features Version 1.0 of rds_embedding is supported. The GanosBase extensions are updated to version 6.0. For more information, see Release notes for GanosBase. Bug fixes Known issues are fixed.
20231030	PostgreSQL 15.4 is supported. New features The TPC feature is supported to compress and decompress page data in a buffer pool in real time. This reduces storage costs and improves I/O throughput. Global parameters can be configured for the TDE feature. After you configure global parameters, new tables and indexes are encrypted by default. Bug fixes The GanosBase extensions are updated to version 5.9 to fix known issues.
20230830	PostgreSQL 15.4 is supported. New features The cache eviction feature is supported. Version 1.1.0 of postgresql_anonymizer is supported. The pgvector extension is updated to version 0.5.0 and supports HNSW indexes, construction of IVFFlat parallel indexes, element-by-element multiplication of vectors, L1 distance functions, and sum aggregation. The GanosBase extensions are updated to version 5.8. For more information, see Release notes for GanosBase. Bug fixes Known issues are fixed.
20230730	PostgreSQL 15.1 is supported. New features None. Bug fixes Known issues are fixed.
20230630	PostgreSQL 15.1 is supported. New features A new feature that allows you to specify whether to use default dictionaries during searches is supported for the pg_jieba extension. Bug fixes None.
20230530	PostgreSQL 15.1 is supported. New features Version 4.7.3 of pg_partman is supported. The pg_cron extension is updated to version 1.5. The GanosBase extensions are updated to version 5.6. For more information, see Release notes for GanosBase. Bug fixes The bug due to which the profile database fails to connect to the server database when the pg_profile extension is used is fixed.
20230430	PostgreSQL 15.1 is supported. New features ICU collations are supported. Version 0.4.1 of pgvector is supported. The rds_ccl extension is updated to version 1.1. The GanosBase extensions are updated to version 5.5. For more information, see Release notes for GanosBase. Bug fixes The bug due to which the DROP DATABASE statement fails to be executed when the pg_cron and pglogical extensions are used is fixed.
20230330	PostgreSQL 15.1 is supported. New features Version 1.0 of the rds_ccl self-developed extension is supported. You can use this extension for SQL throttling. Bug fixes The bug that audit logs and slow query logs cannot be collected due to abnormal output locations is fixed. Other known issues are fixed.
20230228	PostgreSQL 15.1 is supported. New features Version 2.9.2 of the timescaledb extension is supported. Version 1.5 of the pg_hint_plan extension is supported. Version 2.4 of the ip4r extension is supported. Version 2.1 of the pgl_ddl_deploy extension is supported. The GanosBase extensions are updated to version 5.4. For more information, see Release notes for GanosBase. The pgrouting extension is updated to version 3.4.2. Bug fixes None.
20221230	PostgreSQL 15.1 is supported. New features Version 0.0.1 of the PASE extension is supported. The GanosBase extensions are updated to version 5.3. For more information, see Release notes for GanosBase. Bug fixes None.
20221030	PostgreSQL 15.1 is supported. This is the initial release. For more information about the supported features, see Features. For more information about the supported extensions, see Supported extensions.

PostgreSQL 14

Version	Description
20250430	PostgreSQL 14.17 is supported. New features Version 1.0.0 of AI (rds_ai) is supported. Bug fixes The security vulnerability in the pg_cron extension is fixed, and the extension is now supported for new installations. Other known issues are fixed.
20250228	PostgreSQL 14.17 is supported. New features The rds_ccl extension is updated to version 1.2. The search_path parameter can be configured when you perform SQL throttling based on the specified query_id value. Bug fixes Known issues are fixed.
20241230	PostgreSQL 14.13 is supported. New features The pgvector extension is updated to version 0.8.0. The pg_hint_plan extension is updated to version 1.4.3. Bug fixes Known issues are fixed.
20241030	PostgreSQL 14.13 is supported. New features Version 1.1 of rds_duckdb is supported. The GanosBase extensions are updated to version 6.9. For more information, see Release notes for GanosBase. Bug fixes Known issues are fixed.
20240830	PostgreSQL 14.13 is supported. New features Version 1.5.0 of age is supported. The wal2json extension is updated to version 2.6. The hll extension is updated to version 2.18. The pg_repack extension is updated to version 1.5.0. The hypopg extension is updated to version 1.4.1. The pgvector extension is updated to version 0.7.4. The pg_partman extension is updated to version 5.1.0. The encdb extension is updated to version 1.1.14. Bug fixes Known issues are fixed.
20240730	PostgreSQL 14.12 is supported. New features None. Bug fixes Known issues are fixed.
20240530	PostgreSQL 14.11 is supported. New features Version 0.0.10 of pg_proctab is supported. The pgvector extension is updated to version 0.7.0. Bug fixes Known issues are fixed.
20240229	PostgreSQL 14.11 is supported. New features Version 1.6 of pg_squeeze is supported. The timescaledb extension is updated to version 2.14.2. The pgvector extension is updated to version 0.6.0. The pglogical extension is updated to version 2.4.4. The mysql_fdw extension is updated to version 1.2. The orafce extension is updated to version 4.9.2. The pg_cron extension is updated to version 1.6. The pg_stat_kcache extension is updated to version 2.2.3. The pg_profile extension is updated to version 4.4. The pgl_ddl_deploy extension is updated to version 2.2. The pg_partman extension is updated to version 5.0.1. The postgis, postgis_sfcgal, postgis_tiger_geocoder, and postgis_topology extensions are updated to version 3.3.4. The GanosBase extensions are updated to version 6.3. For more information, see Release notes for GanosBase. Bug fixes Known issues are fixed.
20231230	PostgreSQL 14.10 is supported. New features Version 1.0 of rds_embedding is supported. The GanosBase extensions are updated to version 6.0. For more information, see Release notes for GanosBase. Bug fixes Known issues are fixed.
20231030	PostgreSQL 14.9 is supported. New features The TPC feature is supported to compress and decompress page data in a buffer pool in real time. This reduces storage costs and improves I/O throughput. Global parameters can be configured for the TDE feature. After you configure global parameters, new tables and indexes are encrypted by default. Bug fixes The GanosBase extensions are updated to version 5.9 to fix known issues.
20230830	PostgreSQL 14.9 is supported. New features The cache eviction feature is supported. Version 1.1.0 of postgresql_anonymizer is supported. The pgvector extension is updated to version 0.5.0 and supports HNSW indexes, construction of IVFFlat parallel indexes, element-by-element multiplication of vectors, L1 distance functions, and sum aggregation. The GanosBase extensions are updated to version 5.8. For more information, see Release notes for GanosBase. Bug fixes Known issues are fixed.
20230630	PostgreSQL 14.6 is supported. New features A new feature that allows you to specify whether to use default dictionaries during searches is supported for the pg_jieba extension. Bug fixes None.
20230530	PostgreSQL 14.6 is supported. New features Version 4.7.3 of pg_partman is supported. The pg_cron extension is updated to version 1.5. The GanosBase extensions are updated to version 5.6. For more information, see Release notes for GanosBase. Bug fixes The bug due to which the profile database fails to connect to the server database when the pg_profile extension is used is fixed.
20230430	PostgreSQL 14.6 is supported. New features ICU collations are supported. Version 0.4.1 of pgvector is supported. The rds_ccl extension is updated to version 1.1. The GanosBase extensions are updated to version 5.5. For more information, see Release notes for GanosBase. Bug fixes The performance of the pg_jieba extension is optimized to fix the out of memory (OOM) issue when loading super-large dictionaries.
20230330	PostgreSQL 14.6 is supported. New features Version 1.0 of the rds_ccl self-developed extension is supported. You can use this extension for SQL throttling. The timescaledb extension is updated to version 2.9.2. Bug fixes Some known issues are fixed.
20230228	PostgreSQL 14.6 is supported. New features The GanosBase extensions are updated to version 5.4. For more information, see Release notes for GanosBase. Version 2.4 of the ip4r extension is supported. Version 2.1 of the pgl_ddl_deploy extension is supported. The pgrouting extension is updated to version 3.4.2. The pglogical extension is updated to version 2.4.2. Bug fixes None.
20221230	PostgreSQL 14.6 is supported. New features The GanosBase extensions are updated to version 5.3. For more information, see Release notes for GanosBase. Version 0.0.1 of the PASE extension is supported. The postgis extension is updated to version 3.3.2. The encdb extension is updated to version 1.1.12. Bug fixes None.
20221030	PostgreSQL 14.5 is supported. New features The GanosBase extensions are updated to version 5.1. For more information, see Release notes for GanosBase. The TDE feature is supported to achieve table-level transparent data encryption. Version 1.0 of the rds_tde_utils extension is supported. Version 4.1 of the pg_profile extension is supported. Version 2.2.1 of the pg_stat_kcache extension is supported. Version 1.1 of the mysql_fdw extension is supported. Version 1.4.7 of the pg_repack extension is supported. Version 1.0 of the zhparser extension is supported. Version 1.3 of the rum extension is supported. Version 2.3.15 of the plv8 extension is supported. Version 1.4.0 of the pg_hint_plan extension is supported. Version 2.0.3 of the tds_fdw extension is supported. Bug fixes None.
20220830	PostgreSQL 14.4 is supported. New features The encdb extension is updated to version 1.1.1. Version 1.1 of the oss_fdw extension is supported. Version 2.5.0 of the timescaledb extension is supported. The memory usage of the index_adviser extension is optimized. Bug fixes The bug due to which the index_adviser extension accesses memory out of bounds in complex queries is fixed.
20220730	PostgreSQL 14.4 is supported. New features The GanosBase extensions are updated to version 4.9. For more information, see Release notes for GanosBase. The ST_Intersection aggregate function is added to aggregate an array of geometry objects. The ST_AddZ function is added to accept z-axis values as the value of an input parameter and convert a 2D or 3DM geometry to a 3D or 4D geometry. The ST_SetValue function is enhanced to set pixel values based on the spatial range of a geometry object. The ST_ExportTo function is enhanced to export raster objects as COG files. The ST_CreateRast function is enhanced to convert multiple raster records or arrays into raster objects. The ST_Split function is enhanced to support the settings of start time when you want to split a trajectory by time. The enhanced function also supports the splitting of a trajectory by trajectory point index. The ST_Union function is enhanced to support batch execution based on memory usage to prevent OOM errors caused by large data volumes. Hadoop Distributed File System (HDFS)-based operations on raster data are supported. The pg_jieba extension that is used to segment Chinese text is supported. The extension supports custom dictionaries and allows you to switch between dictionaries. The extension displays segmentation results based on the offset of each field. Bug fixes The bug due to which the index_adviser extension fails to respond when all recommended indexes already exist is fixed.
20220630	PostgreSQL 14.4 is supported. New features The GanosBase extensions are updated to version 4.7. For more information, see Release notes for GanosBase. The ST_makeTrajectory function is enhanced to convert table rows to trajectory objects. The ST_AsTable function is added to convert trajectories into tables. Bug fixes The bug of silent corruption of indexes caused by "CREATE INDEX CONCURRENTLY" / "REINDEX CONCURRENTLY" is fixed.
20220228	PostgreSQL 14.1 is supported. New features Version 1.0.2 of the sequential-uuids extension is supported. The encdb extension is updated to version 1.1.9. The GanosBase extensions are updated to version 4.6. For more information, see Release notes for GanosBase. Raster data stored in self-managed MinIO buckets can be accessed. For more information, see Object storage paths. The ST_PointValues function is added to return the pixel values of all bands. Standard accounts are granted the permissions to execute the LOAD statement to load the index_adviser and pg_hint_plan extensions. Privileged accounts are granted the permissions to configure the BYPASSRLS parameter in the CREATE ROLE statement. Bug fixes The bug that causes missing parameter values in slow SQL logs is fixed.
20220130	PostgreSQL 14.1 is supported. New features: Version 2.0 of the index_adviser extension is supported. Version 1.3.1 of the hypopg extension is supported. The GanosBase extensions are updated to version 4.5. For more information, see Release notes for GanosBase. The encdb extension is updated to version 1.1.7. The pg_cron extension is updated to version 1.1. The roaringbitmap extension is updated to version 0.5.
20211130	PostgreSQL 14.1 is supported. This is the initial release. For more information about the supported features, see Features. For more information about the supported extensions, see Supported extensions.