AliPG engine version update instructions (PostgreSQL 14–18) - ApsaraDB RDS

This topic describes the updates for the AliPG minor engine versions of ApsaraDB RDS for PostgreSQL 14–18.

Important

To use the new features of a minor engine version, you must upgrade the minor engine version of your instance. For more information, see View and upgrade the minor engine version of an instance.
For release notes about other AliPG minor engine versions, see AliPG minor engine version release notes (PostgreSQL 9.4–13).

PostgreSQL 18

Minor version

Description

20251130

Compatible with community PostgreSQL 18.1.

Initial release.

For information about supported features, see Feature overview.
For supported extensions, see List of extensions supported by RDS PostgreSQL.

PostgreSQL 17

Minor version	Description
20251130	Compatible with community PostgreSQL 17.6. New features The rds_duckdb extension supports read-only ApsaraDB RDS for PostgreSQL instances. The hll extension is upgraded to 2.19. Added support for the pgroonga extension, version V4.0.4. Added support for the hll extension, version V2.19. Added support for the clickhouse_fdw extension, version V1.4. Added support for the pg_permissions extension, version V1.4. Added support for the age extension, version 1.6.0. Added support for the online partitioning (rds_online_migrate) extension, version V1.0. Bug fixes Fixed known issues.
20250830	Compatible with community PostgreSQL 17.6. New features Added support for the Online DDL (rds_online_ddl) extension, version 1.0. Added support for the fuzzy query (pg_bigm) extension, version 1.2. Bug fixes Fixed known issues.
20250630	Compatible with community PostgreSQL 17.5. New features Added support for the snowflake extension, version 2.2. Added support for the stored procedure debugger (pldebugger) extension, version 1.8. Bug fixes Fixed known issues.
20250430	Compatible with community PostgreSQL 17.4. New features Added support for the AI (rds_ai) (1.0.0), high-speed full-text search (RUM) (1.3), scheduled task (pg_cron) (1.6), and pg_partman (5.2.4) extensions. For more information, see List of extensions supported by ApsaraDB RDS for PostgreSQL. Bug fixes Fixed known issues.
20250228	Compatible with community PostgreSQL 17.4. New features The rds_ccl extension is upgraded to 1.2. When you throttle SQL statements based on query_id, you can configure the search_path parameter. Bug fixes Fixed known issues.
20241230	Compatible with community PostgreSQL 17.0. New features Added support for the pgsql-gzip extension, version 1.0.0. The pgvector extension is upgraded to 0.8.0. Added the feature to automatically update time columns. Bug fixes Fixed known issues.
20241030	Compatible with community PostgreSQL 17.0. New features Supports the GanosBase plugin, version 7.0. For more information, see Spatio-temporal Engine version release history. Supports the rds_duckdb (1.1), smlar (1.0), pglogical (2.4.5), mysql_fdw (2.9.2), pgaudit (17.0), pg_repack (1.5.1), pg_wait_sampling (1.1), timescaledb (2.17.0), zhparser (1.0), pg_hint_plan (1.7.0), tds_fdw (2.0.4), ip4r (2.4), pg_squeeze (1.7), hypopg (1.4.1), roaringbitmap (0.5.4), rds_embedding (1.0), sequential-uuids (1.0.2), pg_jieba (1.2.0), pg_stat_kcache (2.3.0), postgresql_anonymizer (1.1.0), pg_proctab (0.0.10), postgis (3.3.7), address_standardizer (3.3.7), address_standardizer_data_us (3.3.7), postgis_sfcgal (3.3.7), postgis_tiger_geocoder (3.3.7), postgis_topology (3.3.7), pgrouting (3.4.2), and pgvector (0.7.4) extensions. For more information, see List of extensions supported by ApsaraDB RDS for PostgreSQL. Bug fixes Fixed known issues.
20240930	Compatible with community PostgreSQL 17.0. Initial release. For information about supported features, see Feature overview. For information about supported extensions, see List of extensions supported by ApsaraDB RDS for PostgreSQL.

PostgreSQL 16

Minor version	Description
20251130	Compatible with community PostgreSQL 16.10. New features The rds_duckdb extension supports read-only ApsaraDB RDS for PostgreSQL instances. The pglogical extension is upgraded to 2.4.5. Added support for the online partitioning (rds_online_migrate) extension, version V1.0. Added support for the clickhouse_fdw extension, version V1.4. Added support for the age extension, version V1.6.0. Bug fixes Fixed known issues.
20250830	Compatible with community PostgreSQL 16.10. New features Added support for the Online DDL (rds_online_ddl) extension, version 1.0. Bug fixes Fixed known issues.
20250630	Compatible with community PostgreSQL 16.9. New features Added support for the snowflake extension, version 2.2. Added support for the stored procedure debugger (pldebugger) extension, version 1.8. Bug fixes Fixed known issues.
20250430	Compatible with community PostgreSQL 16.8. New features None. Bug fixes Fixed a security vulnerability in the scheduled task (pg_cron) extension and re-enabled the creation of this extension. Fixed other known issues.
20250228	Compatible with community PostgreSQL 16.8. New features Added support for the rds_encdb extension, version 1.0. Important When you enable the column encryption feature, the rds_encdb extension is installed in the destination database by default. You cannot manually install this extension in the destination database. To install it, contact us. The rds_ccl extension is upgraded to 1.2. When you throttle SQL statements based on query_id, you can configure the search_path parameter. Bug fixes Fixed known issues.
20241230	Compatible with community PostgreSQL 16.4. New features Added support for the AI (rds_ai) extension, version 1.0.0. Added support for the pgsql-http extension, version 1.6. Added support for the pgsql-gzip extension, version 1.0.0. The pgvector extension is upgraded to 0.8.0. The pg_hint_plan extension is upgraded to 1.6.1. The rds_duckdb extension is upgraded to 1.2 and supports DML incremental synchronization. Added the feature to automatically update time columns. Bug fixes Fixed known issues.
20241030	Compatible with community PostgreSQL 16.4. New features The rds_duckdb extension is upgraded to 1.1. The GanosBase extension is upgraded to 6.9. For more information, see Spatio-temporal Engine Release Notes. Bug fixes Fixed known issues.
20240830	Compatible with community PostgreSQL 16.4. New features Added support for the age extension, version 1.5.0. (Invitational preview) Added support for the rds_duckdb extension, version 1.0. Added support for the rds_embedding extension, version 1.0. Added support for the wal2json extension, version 2.6. Added support for the hypopg extension, version 1.4.1. Added support for the pg_bigm extension, version 1.2. Added support for the roaringbitmap extension, version 0.5.4. The pg_repack extension is upgraded to 1.5.0. The pgvector extension is upgraded to 0.7.4. The pg_partman extension is upgraded to 5.1.0. The encdb extension is upgraded to 1.1.14. Bug fixes Fixed other known issues.
20240730	Compatible with community PostgreSQL 16.3. New features None. Bug fixes Fixed known issues.
20240530	Compatible with community PostgreSQL 16.2. New features Added support for the pg_proctab extension, version 0.0.10. The pgvector extension is upgraded to 0.7.0. Bug fixes Fixed known issues.
20240229	Compatible with community PostgreSQL 16.2. New features Added support for the pg_squeeze extension, version 1.6. The timescaledb extension is upgraded to 2.14.2. The pgvector extension is upgraded to 0.6.0. The orafce extension is upgraded to 4.9.2. The pg_stat_kcache extension is upgraded to 2.2.3. The pg_profile extension is upgraded to 4.4. The pg_partman extension is upgraded to 5.0.1. The GanosBase plugin is upgraded to 6.3. For more information, see Spatio-temporal Engine Version Release Record. Bug fixes Fixed known issues.
20231230	Compatible with community PostgreSQL 16.1. Bug fixes Fixed known issues.
20231030	Compatible with community PostgreSQL 16.0. Initial release. For information about supported features, see Feature overview. For information about supported extensions, see List of extensions supported by ApsaraDB RDS for PostgreSQL.

PostgreSQL 15

Minor version	Description
20251130	Compatible with community PostgreSQL 15.14. New features Added support for the online partitioning (rds_online_migrate) extension, version V1.0. Added support for the clickhouse_fdw extension, version V1.4. Bug fixes Fixed known issues.
20250830	Compatible with community PostgreSQL 15.14. New features Added support for the Online DDL (rds_online_ddl) extension, version 1.0. Bug fixes Fixed known issues.
20250630	Compatible with community PostgreSQL 15.13. New features Added support for the snowflake extension, version 2.2. Added support for the stored procedure debugger (pldebugger) extension, version 1.8. Bug fixes Fixed known issues.
20250430	Compatible with community PostgreSQL 15.12. New features Added support for the AI (rds_ai) extension, version 1.0.0. Bug fixes Fixed a security vulnerability in the scheduled task (pg_cron) extension and re-enabled the creation of this extension. Fixed other known issues.
20250228	Compatible with community PostgreSQL 15.12. New features The rds_ccl extension is upgraded to 1.2. When you throttle SQL statements based on query_id, you can configure the search_path parameter. The rds_duckdb extension is upgraded to 1.3 and supports automatic incremental synchronization of data in column-oriented tables. Bug fixes Fixed known issues.
20241230	Compatible with community PostgreSQL 15.8. New features The pgvector extension is upgraded to 0.8.0. The pg_hint_plan extension is upgraded to 1.5.2. The rds_duckdb extension is upgraded to 1.2 and supports DML incremental synchronization. Added the feature to automatically update time columns. Bug fixes Fixed known issues.
20241030	Compatible with community PostgreSQL 15.8. New features Supports the rds_duckdb extension, version 1.1. The GanosBase plugin is upgraded to 6.9. For more information, see Spatiotemporal Engine Release Notes. Bug fixes Fixed known issues.
20240830	Compatible with community PostgreSQL 15.8. New features Added support for the age extension, version 1.5.0. The wal2json extension is upgraded to 2.6. The hll extension is upgraded to 2.18. The pg_repack extension is upgraded to 1.5.0. The hypopg extension is upgraded to 1.4.1. The pgvector extension is upgraded to 0.7.4. The pg_partman extension is upgraded to 5.1.0. The encdb extension is upgraded to 1.1.14. Bug fixes Fixed other known issues.
20240730	Compatible with community PostgreSQL 15.7. New features None. Bug fixes Fixed known issues.
20240530	Compatible with community PostgreSQL 15.6. New features Added support for the pg_proctab extension, version 0.0.10. The pgvector extension is upgraded to 0.7.0. Bug fixes Fixed known issues.
20240229	Compatible with community PostgreSQL 15.6. New features Added support for the pg_squeeze extension, version 1.6. The timescaledb extension is upgraded to 2.14.2. The pgvector extension is upgraded to 0.6.0. The pglogical extension is upgraded to 2.4.4. The mysql_fdw extension is upgraded to 1.2. The orafce extension is upgraded to 4.9.2. The pg_cron extension is upgraded to 1.6. The pg_stat_kcache extension is upgraded to 2.2.3. The pg_profile extension is upgraded to 4.4. The pgl_ddl_deploy extension is upgraded to 2.2. The pg_partman extension is upgraded to 5.0.1. The postgis, postgis_sfcgal, postgis_tiger_geocoder, and postgis_topology extensions are upgraded to 3.3.4. The GanosBase plugin is upgraded to 6.3. For more information, see the Spatio-temporal Engine Version Release Notes. Bug fixes Fixed known issues.
20231230	Compatible with community PostgreSQL 15.5. New features Added support for the rds_embedding extension, version 1.0. The GanosBase plugin is upgraded to 6.0. For more information, see Spatio-temporal Engine version release history. Bug fixes Fixed known issues.
20231030	Compatible with community PostgreSQL 15.4. New features Added the transparent page compression (TPC) feature. This feature performs real-time compression and decompression of page data in the buffer pool to reduce storage costs and improve I/O throughput. The transparent data encryption feature supports setting a global parameter to encrypt tables and indexes by default upon creation. Bug fixes GanosBase plugin is upgraded to 5.9. Known issues are fixed.
20230830	Compatible with community PostgreSQL 15.4. New features Added support for the cache eviction feature. Added the postgresql_anonymizer extension, version 1.1.0. The pgvector extension is upgraded to 0.5.0. It supports HNSW indexes, parallel index building for IVFFlat, element-wise multiplication of vectors, the L1 distance function, and sum aggregation. The GanosBase plugin has been upgraded to 5.8. For more information, see the Spatiotemporal Engine Release Notes. Bug fixes Fixed known issues.
20230730	Compatible with community PostgreSQL 15.1. New features None. Bug fixes Fixed known issues.
20230630	Compatible with community PostgreSQL 15.1. New features The pg_jieba extension supports setting whether to use the default dictionary during retrieval. Bug fixes None.
20230530	Compatible with community PostgreSQL 15.1. New features Added support for the pg_partman extension, version 4.7.3. The pg_cron extension is upgraded to 1.5. The GanosBase plugin is upgraded to 5.6. For more information, see Spatiotemporal Engine Version Release Notes. Bug fixes Fixed an issue where the database connection from the profile database to the server database failed when the pg_profile extension was used.
20230430	Compatible with community PostgreSQL 15.1. New features Added support for ICU Collations. Added support for the pgvector extension, version 0.4.1. The rds_ccl extension is upgraded to 1.1. The / GanosBase plugin is upgraded to 5.5. For more information, see Spatiotemporal Engine Release Notes. Bug fixes Fixed an issue where DROP DATABASE failed when using the pg_cron and pglogical plugins.
20230330	Compatible with community PostgreSQL 15.1. New features Added the self-developed rds_ccl extension, which supports SQL throttling. Version: 1.0. Bug fixes Fixed an issue where audit logs and slow query logs could not be collected due to an abnormal output location. Fixed other known issues.
20230228	Compatible with community PostgreSQL 15.1. New features Added support for the timescaledb extension, version 2.9.2. Added support for the pg_hint_plan extension, version 1.5. Added support for the ip4r extension, version 2.4. Added support for the pgl_ddl_deploy extension, version 2.1. The GanosBase plugin is upgraded to 5.4. For more information, see Spatio-temporal Engine Version Release Notes. The pgrouting extension is upgraded to 3.4.2. Bug fixes None.
20221230	Compatible with community PostgreSQL 15.1. New features Added support for the pase extension, version 0.0.1. The GanosBase plugin is upgraded to 5.3. For more information, see Spatiotemporal Engine version release notes. Bug fixes None.
20221030	Compatible with community PostgreSQL 15.1. Initial release. For information about supported features, see Feature overview. For information about supported extensions, see List of extensions supported by ApsaraDB RDS for PostgreSQL.

PostgreSQL 14

Minor version	Description
20251130	Compatible with community PostgreSQL 14.19. New features Added support for the online partitioning (rds_online_migrate) extension, version V1.0. Added support for the clickhouse_fdw extension, version V1.4. Bug fixes Fixed known issues.
20250830	Compatible with community PostgreSQL 14.19. New features Added support for 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 support for the stored procedure debugger (pldebugger) extension, version 1.8. Bug fixes Fixed known issues.
20250430	Compatible with community PostgreSQL 14.17. New features Added support for the AI (rds_ai) extension, version 1.0.0. Bug fixes Fixed a security vulnerability in the scheduled task (pg_cron) extension and re-enabled the creation of this extension. Fixed other known issues.
20250228	Compatible with community PostgreSQL 14.17. New features The rds_ccl extension is upgraded to 1.2. When you throttle SQL statements based on query_id, you can configure the search_path parameter. Bug fixes Fixed known issues.
20241230	Compatible with community PostgreSQL 14.13. New features The pgvector extension is upgraded to 0.8.0. The pg_hint_plan extension is upgraded to 1.4.3. Bug fixes Fixed known issues.
20241030	Compatible with community PostgreSQL 14.13. New features Supports the rds_duckdb extension, version 1.1. The GanosBase plugin is upgraded to 6.9. For more information, see Spatiotemporal Engine Version Release History. Bug fixes Fixed known issues.
20240830	Compatible with community PostgreSQL 14.13. New features Added support for the age extension, version 1.5.0. The wal2json extension is upgraded to 2.6. The hll extension is upgraded to 2.18. The pg_repack extension is upgraded to 1.5.0. The hypopg extension is upgraded to 1.4.1. The pgvector extension is upgraded to 0.7.4. The pg_partman extension is upgraded to 5.1.0. The encdb extension is upgraded to 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 support for the pg_proctab extension, version 0.0.10. The pgvector extension is upgraded to 0.7.0. Bug fixes Fixed known issues.
20240229	Compatible with community PostgreSQL 14.11. New features Added support for the pg_squeeze extension, version 1.6. The timescaledb extension is upgraded to 2.14.2. The pgvector extension is upgraded to 0.6.0. The pglogical extension is upgraded to 2.4.4. The mysql_fdw extension is upgraded to 1.2. The orafce extension is upgraded to 4.9.2. The pg_cron extension is upgraded to 1.6. The pg_stat_kcache extension is upgraded to 2.2.3. The pg_profile extension is upgraded to 4.4. The pgl_ddl_deploy extension is upgraded to 2.2. The pg_partman extension is upgraded to 5.0.1. The postgis, postgis_sfcgal, postgis_tiger_geocoder, and postgis_topology extensions are upgraded to 3.3.4. The GanosBase plugin is upgraded to 6.3. For more information, see Spatiotemporal Engine Version Release Notes. Bug fixes Fixed known issues.
20231230	Compatible with community PostgreSQL 14.10. New features Added support for the rds_embedding extension, version 1.0. The GanosBase plugin is upgraded to 6.0. For more information, see Spatio-temporal Engine version release notes. Bug fixes Fixed known issues.
20231030	Compatible with community PostgreSQL 14.9. New features Added the transparent page compression (TPC) feature. This feature performs real-time compression and decompression of page data in the buffer pool to reduce storage costs and improve I/O throughput. The transparent data encryption feature supports setting a global parameter to encrypt tables and indexes by default upon creation. Bug fixes The and GanosBase plugins are upgraded to 5.9, and known issues are fixed.
20230830	Compatible with community PostgreSQL 14.9. New features Added support for the cache eviction feature. Added the postgresql_anonymizer extension, version 1.1.0. The pgvector extension is upgraded to 0.5.0. It supports HNSW indexes, parallel index building for IVFFlat, element-wise multiplication of vectors, the L1 distance function, and sum aggregation. GanosBase plugin is upgraded to 5.8. For more information, see Spatiotemporal Engine Version Release Notes. Bug fixes Fixed known issues.
20230630	Compatible with community PostgreSQL 14.6. New features The pg_jieba extension supports setting whether to use the default dictionary during retrieval. Bug fixes None.
20230530	Compatible with community PostgreSQL 14.6. New features Added support for the pg_partman extension, version 4.7.3. The pg_cron extension is upgraded to 1.5. The GanosBase plugin is upgraded to 5.6. For more information, see Spatio-temporal Engine Release Notes. Bug fixes Fixed an issue where the database connection from the profile database to the server database failed when the pg_profile extension was used.
20230430	Compatible with community PostgreSQL 14.6. New features Added support for ICU Collations. Added support for the pgvector extension, version 0.4.1. The rds_ccl extension is upgraded to 1.1. The GanosBase plugin is upgraded to 5.5. For more information, see Spatio-temporal Engine Release Notes. Bug fixes The pg_jieba extension is optimized. An out-of-memory (OOM) issue that occurred when a large dictionary was loaded is fixed.
20230330	Compatible with community PostgreSQL 14.6. New features Added the self-developed rds_ccl extension, which supports SQL throttling. Version: 1.0. The timescaledb extension is upgraded to 2.9.2. Bug fixes Fixed some known issues.
20230228	Compatible with community PostgreSQL 14.6. New features The GanosBase plugin is upgraded to 5.4. For more information, see Spatio-temporal Engine Release Notes. Added support for the ip4r extension, version 2.4. Added support for the pgl_ddl_deploy extension, version 2.1. The pgrouting extension is upgraded to 3.4.2. The pglogical extension is upgraded to 2.4.2. Bug fixes None.
20221230	Compatible with community PostgreSQL 14.6. New features The /GanosBase plugin is upgraded to 5.3. For more information, see the Spatio-temporal Engine release history. Added support for the pase extension, version 0.0.1. The postgis extension is upgraded to 3.3.2. The encdb extension is upgraded to 1.1.12. Bug fixes None.
20221030	Compatible with community PostgreSQL 14.5. New features The GanosBase plugin is upgraded to version 5.1. For more information, see Spatiotemporal Engine Release Notes. Added support for setting transparent data encryption to implement table-level transparent data encryption. Added support for the rds_tde_utils extension, version 1.0. Added support for the pg_profile extension, version 4.1. Added support for the pg_stat_kcache extension, version 2.2.1. Added support for the mysql_fdw extension, version 1.1. Added support for the pg_repack extension, version 1.4.7. Added support for the zhparser extension, version 1.0. Added support for the rum extension, version 1.3. Added support for the plv8 extension, version 2.3.15. Added support for the pg_hint_plan extension, version 1.4.0. Added support for the tds_fdw extension, version 2.0.3. Bug fixes None.
20220830	Compatible with community PostgreSQL 14.4. New features The encdb extension is upgraded to 1.1.1. Added support for the oss_fdw extension, version 1.1. Added support for the timescaledb extension, version 2.5.0. Optimized the memory usage of the index_adviser extension. Bug fixes Fixed an out-of-bounds memory issue of the index_adviser extension during complex queries.
20220730	Compatible with community PostgreSQL 14.4. New features GanosBase plugin has been upgraded to version 4.9. For more information, see Spatiotemporal Engine Release History. The ST_Intersection aggregate function is added to support aggregate operations on Geometry object arrays. The ST_AddZ function is added. It supports passing a Z-coordinate array as a parameter to transform Geometry 2D/3DM to Geometry 3D/4D. The ST_SetValue function is enhanced to support setting pixel values based on the spatial range of a specified geometry object. The ST_ExportTo function is enhanced to support exporting Raster objects as cog files. The ST_CreateRast function is enhanced to support converting multiple records or arrays of regular grid points into raster objects. The ST_Split function is enhanced. When chunking by time, it supports specifying a start time and chunking by the ordinal number of trajectory points. The ST_Union function is enhanced to support batch execution based on memory usage. This prevents out-of-memory (OOM) errors caused by large data volumes. Raster data supports Hadoop Distributed File System (HDFS). The pg_jieba Chinese tokenization extension is added. It supports custom dictionaries, dictionary switching, and displaying tokenization results with offsets for each field. Bug fixes Fixed an issue where the index_adviser extension would crash if all recommended indexes already existed.
20220630	Compatible with community PostgreSQL 14.4 New features GanosBase plugin is upgraded to version 4.7. For more information, see Spatio-temporal Engine Version Release Notes. The ST_makeTrajectory function is enhanced to support converting rows in a table into a trajectory. The ST_AsTable function is added to support converting a trajectory into a table type. Bug fixes Fixed the silent corruption of indexes caused by "CREATE INDEX CONCURRENTLY" or "REINDEX CONCURRENTLY".
20220228	Compatible with community PostgreSQL 14.1 New features Added support for the sequential-uuids extension, version 1.0.2. The encdb extension is upgraded to 1.1.9. The GanosBase plugin has been upgraded to version 4.6. For more information, see the Spatiotemporal Engine version release notes. Raster data supports access to user-created MinIO servers. For more information, see Object Storage Service path. The raster ST_PointValues function is added to return the pixel values of all bands. Standard accounts can run the LOAD command to load the index_adviser and pg_hint_plan extensions. Privileged accounts can configure the BYPASSRLS parameter when they run the CREATE ROLE command. Bug fixes Fixed an issue where parameter values were missing in slow SQL statement logs.
20220130	Compatible with community PostgreSQL 14.1. New features Added support for the index_adviser extension, version 2.0. Added support for the hypopg extension, version 1.3.1. The GanosBase plugin is upgraded to version 4.5. For more information, see Spatiotemporal Engine Version Release Notes. The encdb extension is upgraded to 1.1.7. The pg_cron extension is upgraded to 1.1. The roaringbitmap extension is upgraded to 0.5.
20211130	Compatible with community PostgreSQL 14.1. Initial release. For information about supported features, see Feature overview. For information about supported extensions, see List of extensions supported by ApsaraDB RDS for PostgreSQL.