This document describes the updates for AliPG minor engine versions of ApsaraDB RDS for PostgreSQL 14–18.
Important
To use new features in a minor engine version, 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 earlier 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 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 extensions: pgroonga 4.0.4 (full-text search for multiple languages), hll 2.19, clickhouse_fdw 1.4 (foreign data wrapper for ClickHouse), pg_permissions 1.4 (permission auditing), age 1.6.0 (graph database extension), and online partitioning (rds_online_migrate) 1.0 (online table repartitioning without locking). Updated extensions: hll upgraded to 2.19. Other: rds_duckdb now supports read-only instances. Bug fixes: Fixed known issues. |
| 20250830 | Compatible with community PostgreSQL 17.6. New extensions: Online DDL (rds_online_ddl) 1.0 (schema changes without table locks) and fuzzy query (pg_bigm) 1.2. Bug fixes: Fixed known issues. |
| 20250630 | Compatible with community PostgreSQL 17.5. New extensions: snowflake 2.2 (distributed unique ID generation) and stored procedure debugger (pldebugger) 1.8. Bug fixes: Fixed known issues. |
| 20250430 | Compatible with community PostgreSQL 17.4. New extensions: 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. 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. Updated extensions: rds_ccl upgraded to 1.2 — when throttling SQL statements based on query_id, the search_path parameter is now configurable. Bug fixes: Fixed known issues. |
| 20241230 | Compatible with community PostgreSQL 17.0. New extensions: pgsql-gzip 1.0.0. Updated extensions: pgvector upgraded to 0.8.0. New features: Added the automatic update of time columns feature. Bug fixes: Fixed known issues. |
| 20241030 | Compatible with community PostgreSQL 17.0. New extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase 7.0 (spatiotemporal engine — see Spatiotemporal Engine version release history), 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. 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 supported features, see Feature overview. For 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 extensions: Online partitioning (rds_online_migrate) 1.0, clickhouse_fdw 1.4, and age 1.6.0. Updated extensions: pglogical upgraded to 2.4.5. Other: rds_duckdb now supports read-only instances. Bug fixes: Fixed known issues. |
| 20250830 | Compatible with community PostgreSQL 16.10. New extensions: Online DDL (rds_online_ddl) 1.0. Bug fixes: Fixed known issues. |
| 20250630 | Compatible with community PostgreSQL 16.9. New extensions: snowflake 2.2 and stored procedure debugger (pldebugger) 1.8. Bug fixes: Fixed known issues. |
| 20250430 | Compatible with community PostgreSQL 16.8. Bug fixes: Fixed a security vulnerability in the scheduled task (pg_cron) extension and re-enabled extension creation. Fixed other known issues. |
| 20250228 | Compatible with community PostgreSQL 16.8. New extensions: rds_encdb 1.0 (column-level encryption for sensitive data). Important
When you enable the column encryption feature, rds_encdb is installed in the destination database by default. Do not install it manually. To install it manually, contact us. Updated extensions: rds_ccl upgraded to 1.2 — when throttling SQL statements based on query_id, the search_path parameter is now configurable. Bug fixes: Fixed known issues. |
| 20241230 | Compatible with community PostgreSQL 16.4. New extensions: AI (rds_ai) 1.0.0, pgsql-http 1.6, and pgsql-gzip 1.0.0. Updated extensions: pgvector upgraded to 0.8.0, pg_hint_plan upgraded to 1.6.1, and rds_duckdb upgraded to 1.2 with DML incremental synchronization support. New features: Added the automatic update of time columns feature. Bug fixes: Fixed known issues. |
| 20241030 | Compatible with community PostgreSQL 16.4. Updated extensions: rds_duckdb upgraded to 1.1 and GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 6.9 (see Spatiotemporal Engine release notes). Bug fixes: Fixed known issues. |
| 20240830 | Compatible with community PostgreSQL 16.4. New extensions: age 1.5.0, rds_duckdb 1.0 (invitational preview), rds_embedding 1.0, wal2json 2.6, hypopg 1.4.1, pg_bigm 1.2, and roaringbitmap 0.5.4. Updated extensions: pg_repack upgraded to 1.5.0, pgvector upgraded to 0.7.4, pg_partman upgraded to 5.1.0, and encdb upgraded to 1.1.14. Bug fixes: Fixed known issues. |
| 20240730 | Compatible with community PostgreSQL 16.3. Bug fixes: Fixed known issues. |
| 20240530 | Compatible with community PostgreSQL 16.2. New extensions: pg_proctab 0.0.10. Updated extensions: pgvector upgraded to 0.7.0. Bug fixes: Fixed known issues. |
| 20240229 | Compatible with community PostgreSQL 16.2 . New extensions: pg_squeeze 1.6. Updated extensions: timescaledb upgraded to 2.14.2, pgvector upgraded to 0.6.0, orafce upgraded to 4.9.2, pg_stat_kcache upgraded to 2.2.3, pg_profile upgraded to 4.4, pg_partman upgraded to 5.0.1, and GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 6.3 (see Spatiotemporal Engine version release notes). 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 supported features, see Feature overview. For 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 extensions: Online partitioning (rds_online_migrate) 1.0 and clickhouse_fdw 1.4. Bug fixes: Fixed known issues. |
| 20250830 | Compatible with community PostgreSQL 15.14. New extensions: Online DDL (rds_online_ddl) 1.0. Bug fixes: Fixed known issues. |
| 20250630 | Compatible with community PostgreSQL 15.13. New extensions: snowflake 2.2 and stored procedure debugger (pldebugger) 1.8. Bug fixes: Fixed known issues. |
| 20250430 | Compatible with community PostgreSQL 15.12. New extensions: AI (rds_ai) 1.0.0. Bug fixes: Fixed a security vulnerability in the scheduled task (pg_cron) extension and re-enabled extension creation. Fixed other known issues. |
| 20250228 | Compatible with community PostgreSQL 15.12. Updated extensions: rds_ccl upgraded to 1.2 — when throttling SQL statements based on query_id, the search_path parameter is now configurable. rds_duckdb upgraded to 1.3 with automatic incremental synchronization of data in column-oriented tables. Bug fixes: Fixed known issues. |
| 20241230 | Compatible with community PostgreSQL 15.8. Updated extensions: pgvector upgraded to 0.8.0, pg_hint_plan upgraded to 1.5.2, and rds_duckdb upgraded to 1.2 with DML incremental synchronization support. New features: Added the automatic update of time columns feature. Bug fixes: Fixed known issues. |
| 20241030 | Compatible with community PostgreSQL 15.8. New extensions: rds_duckdb 1.1. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 6.9 (see Spatiotemporal Engine release notes). Bug fixes: Fixed known issues. |
| 20240830 | Compatible with community PostgreSQL 15.8. New extensions: age 1.5.0. Updated extensions: wal2json upgraded to 2.6, hll upgraded to 2.18, pg_repack upgraded to 1.5.0, hypopg upgraded to 1.4.1, pgvector upgraded to 0.7.4, pg_partman upgraded to 5.1.0, and encdb upgraded to 1.1.14. Bug fixes: Fixed known issues. |
| 20240730 | Compatible with community PostgreSQL 15.7. Bug fixes: Fixed known issues. |
| 20240530 | Compatible with community PostgreSQL 15.6. New extensions: pg_proctab 0.0.10. Updated extensions: pgvector upgraded to 0.7.0. Bug fixes: Fixed known issues. |
| 20240229 | Compatible with community PostgreSQL 15.6 . New extensions: pg_squeeze 1.6. Updated extensions: timescaledb upgraded to 2.14.2, pgvector upgraded to 0.6.0, pglogical upgraded to 2.4.4, mysql_fdw upgraded to 1.2, orafce upgraded to 4.9.2, pg_cron upgraded to 1.6, pg_stat_kcache upgraded to 2.2.3, pg_profile upgraded to 4.4, pgl_ddl_deploy upgraded to 2.2, pg_partman upgraded to 5.0.1, and the postgis, postgis_sfcgal, postgis_tiger_geocoder, and postgis_topology extensions upgraded to 3.3.4. GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 6.3 (see Spatiotemporal Engine version release notes). Bug fixes: Fixed known issues. |
| 20231230 | Compatible with community PostgreSQL 15.5. New extensions: rds_embedding 1.0. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 6.0 (see Spatiotemporal 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, which compresses and decompresses page data in the buffer pool in real time to reduce storage costs and improve I/O throughput. Transparent data encryption now supports a global parameter to encrypt tables and indexes by default upon creation. Bug fixes: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.9. Fixed known issues. |
| 20230830 | Compatible with community PostgreSQL 15.4. New extensions: postgresql_anonymizer 1.1.0. New features: Added the cache eviction feature. Updated extensions: pgvector upgraded to 0.5.0 — now supports HNSW indexes, parallel index building for IVFFlat, element-wise multiplication of vectors, the L1 distance function, and sum aggregation. GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.8 (see Spatiotemporal Engine release notes). Bug fixes: Fixed known issues. |
| 20230730 | Compatible with community PostgreSQL 15.1. Bug fixes: Fixed known issues. |
| 20230630 | Compatible with community PostgreSQL 15.1. Updated extensions: pg_jieba now supports configuring whether to use the default dictionary during retrieval. |
| 20230530 | Compatible with community PostgreSQL 15.1. New extensions: pg_partman 4.7.3. Updated extensions: pg_cron upgraded to 1.5 and GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.6 (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 using the pg_profile extension. |
| 20230430 | Compatible with community PostgreSQL 15.1. New features: Added support for ICU Collations. New extensions: pgvector 0.4.1. Updated extensions: rds_ccl upgraded to 1.1 and GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.5 (see Spatiotemporal Engine release notes). Bug fixes: Fixed an issue where DROP DATABASE failed when using the pg_cron and pglogical extensions. |
| 20230330 | Compatible with community PostgreSQL 15.1. New extensions: rds_ccl 1.0 (SQL throttling). 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 extensions: timescaledb 2.9.2, pg_hint_plan 1.5, ip4r 2.4, and pgl_ddl_deploy 2.1. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.4 (see Spatiotemporal Engine version release notes) and pgrouting upgraded to 3.4.2. |
| 20221230 | Compatible with community PostgreSQL 15.1. New extensions: pase 0.0.1. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.3 (see Spatiotemporal Engine version release notes). |
| 20221030 | Compatible with community PostgreSQL 15.1. Initial release. For supported features, see Feature overview. For 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 extensions: Online partitioning (rds_online_migrate) 1.0 and clickhouse_fdw 1.4. Bug fixes: Fixed known issues. |
| 20250830 | Compatible with community PostgreSQL 14.19. New extensions: Online DDL (rds_online_ddl) 1.0. Bug fixes: Fixed known issues. |
| 20250630 | Compatible with community PostgreSQL 14.18. New extensions: stored procedure debugger (pldebugger) 1.8. Bug fixes: Fixed known issues. |
| 20250430 | Compatible with community PostgreSQL 14.17. New extensions: AI (rds_ai) 1.0.0. Bug fixes: Fixed a security vulnerability in the scheduled task (pg_cron) extension and re-enabled extension creation. Fixed other known issues. |
| 20250228 | Compatible with community PostgreSQL 14.17. Updated extensions: rds_ccl upgraded to 1.2 — when throttling SQL statements based on query_id, the search_path parameter is now configurable. Bug fixes: Fixed known issues. |
| 20241230 | Compatible with community PostgreSQL 14.13. Updated extensions: pgvector upgraded to 0.8.0 and pg_hint_plan upgraded to 1.4.3. Bug fixes: Fixed known issues. |
| 20241030 | Compatible with community PostgreSQL 14.13. New extensions: rds_duckdb 1.1. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 6.9 (see Spatiotemporal Engine version release history). Bug fixes: Fixed known issues. |
| 20240830 | Compatible with community PostgreSQL 14.13. New extensions: age 1.5.0. Updated extensions: wal2json upgraded to 2.6, hll upgraded to 2.18, pg_repack upgraded to 1.5.0, hypopg upgraded to 1.4.1, pgvector upgraded to 0.7.4, pg_partman upgraded to 5.1.0, and encdb upgraded to 1.1.14. Bug fixes: Fixed known issues. |
| 20240730 | Compatible with community PostgreSQL 14.12. Bug fixes: Fixed known issues. |
| 20240530 | Compatible with community PostgreSQL 14.11. New extensions: pg_proctab 0.0.10. Updated extensions: pgvector upgraded to 0.7.0. Bug fixes: Fixed known issues. |
| 20240229 | Compatible with community PostgreSQL 14.11 . New extensions: pg_squeeze 1.6. Updated extensions: timescaledb upgraded to 2.14.2, pgvector upgraded to 0.6.0, pglogical upgraded to 2.4.4, mysql_fdw upgraded to 1.2, orafce upgraded to 4.9.2, pg_cron upgraded to 1.6, pg_stat_kcache upgraded to 2.2.3, pg_profile upgraded to 4.4, pgl_ddl_deploy upgraded to 2.2, pg_partman upgraded to 5.0.1, and the postgis, postgis_sfcgal, postgis_tiger_geocoder, and postgis_topology extensions upgraded to 3.3.4. GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 6.3 (see Spatiotemporal Engine version release notes). Bug fixes: Fixed known issues. |
| 20231230 | Compatible with community PostgreSQL 14.10. New extensions: rds_embedding 1.0. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 6.0 (see Spatiotemporal 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, which compresses and decompresses page data in the buffer pool in real time to reduce storage costs and improve I/O throughput. Transparent data encryption now supports a global parameter to encrypt tables and indexes by default upon creation. Bug fixes: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.9. Fixed known issues. |
| 20230830 | Compatible with community PostgreSQL 14.9. New extensions: postgresql_anonymizer 1.1.0. New features: Added the cache eviction feature. Updated extensions: pgvector upgraded to 0.5.0 — now supports HNSW indexes, parallel index building for IVFFlat, element-wise multiplication of vectors, the L1 distance function, and sum aggregation. GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.8 (see Spatiotemporal Engine version release notes). Bug fixes: Fixed known issues. |
| 20230630 | Compatible with community PostgreSQL 14.6. Updated extensions: pg_jieba now supports configuring whether to use the default dictionary during retrieval. |
| 20230530 | Compatible with community PostgreSQL 14.6. New extensions: pg_partman 4.7.3. Updated extensions: pg_cron upgraded to 1.5 and GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.6 (see Spatiotemporal Engine release notes). Bug fixes: Fixed an issue where the database connection from the profile database to the server database failed when using the pg_profile extension. |
| 20230430 | Compatible with community PostgreSQL 14.6. New features: Added support for ICU Collations. New extensions: pgvector 0.4.1. Updated extensions: rds_ccl upgraded to 1.1 and GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.5 (see Spatiotemporal Engine release notes). Bug fixes: Fixed an out-of-memory (OOM) issue in the pg_jieba extension that occurred when loading large dictionaries. |
| 20230330 | Compatible with community PostgreSQL 14.6. New extensions: rds_ccl 1.0 (SQL throttling). Updated extensions: timescaledb upgraded to 2.9.2. Bug fixes: Fixed some known issues. |
| 20230228 | Compatible with community PostgreSQL 14.6. New extensions: ip4r 2.4 and pgl_ddl_deploy 2.1. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.4 (see Spatiotemporal Engine release notes), pgrouting upgraded to 3.4.2, and pglogical upgraded to 2.4.2. |
| 20221230 | Compatible with community PostgreSQL 14.6. New extensions: pase 0.0.1. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.3 (see Spatiotemporal Engine release history), postgis upgraded to 3.3.2, and encdb upgraded to 1.1.12. |
| 20221030 | Compatible with community PostgreSQL 14.5. New extensions: rds_tde_utils 1.0, pg_profile 4.1, pg_stat_kcache 2.2.1, mysql_fdw 1.1, pg_repack 1.4.7, zhparser 1.0, rum 1.3, plv8 2.3.15, pg_hint_plan 1.4.0, and tds_fdw 2.0.3. New features: Added support for table-level transparent data encryption. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 5.1 (see Spatiotemporal Engine release notes). |
| 20220830 | Compatible with community PostgreSQL 14.4. New extensions: oss_fdw 1.1 and timescaledb 2.5.0. Updated extensions: encdb upgraded to 1.1.1. Optimized memory usage of the index_adviser extension. Bug fixes: Fixed an out-of-bounds memory issue in the index_adviser extension that occurred during complex queries. |
| 20220730 | Compatible with community PostgreSQL 14.4. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 4.9 (see Spatiotemporal Engine release history) with the following additions: ST_Intersection aggregate function for Geometry arrays, ST_AddZ to transform 2D/3DM geometry to 3D/4D, enhanced ST_SetValue for setting pixel values based on geometry spatial range, enhanced ST_ExportTo for exporting Raster objects as COG files, enhanced ST_CreateRast for converting grid-point arrays into raster objects, enhanced ST_Split with time-based chunking by ordinal trajectory point number, memory-aware batch execution for ST_Union to prevent out-of-memory (OOM) errors on large datasets, and Hadoop Distributed File System (HDFS) support for raster data. New extensions: pg_jieba (Chinese tokenization with custom dictionaries, dictionary switching, and offset-based tokenization results). Bug fixes: Fixed an issue where the index_adviser extension crashed when all recommended indexes already existed. |
| 20220630 | Compatible with community PostgreSQL 14.4. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 4.7 (see Spatiotemporal Engine version release notes) with enhanced ST_makeTrajectory for converting table rows into trajectories and new ST_AsTable for converting trajectories into table types. Bug fixes: Fixed the silent corruption of indexes caused by CREATE INDEX CONCURRENTLY or REINDEX CONCURRENTLY. |
| 20220228 | Compatible with community PostgreSQL 14.1. New extensions: sequential-uuids 1.0.2. New features: Standard 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 running the CREATE ROLE command. Updated extensions: encdb upgraded to 1.1.9. GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 4.6 (see Spatiotemporal Engine version release notes) — raster data now supports access to user-created MinIO servers (see Object Storage Service path) and includes the new raster ST_PointValues function, which returns pixel values for all bands. Bug fixes: Fixed an issue where parameter values were missing in slow SQL statement logs. |
| 20220130 | Compatible with community PostgreSQL 14.1. New extensions: index_adviser 2.0 and hypopg 1.3.1. Updated extensions: GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBaseGanosBase upgraded to 4.5 (see Spatiotemporal Engine version release notes), encdb upgraded to 1.1.7, pg_cron upgraded to 1.1, and roaringbitmap upgraded to 0.5. |
| 20211130 | Compatible with community PostgreSQL 14.1. Initial release. For supported features, see Feature overview. For supported extensions, see List of extensions supported by ApsaraDB RDS for PostgreSQL. |