AWS AmazonRDS documentation change
Summary
Added documentation for PostgreSQL versions 18.1, 17.7, 16.11, 15.15, 14.20, and 13.23 on Amazon RDS, including parameter updates, new extensions (pgcollection, roaringbitmap), extension version updates (pgaudit, pg_tle, etc.), and removal of some extensions for v18
Security assessment
Updates include security-adjacent parameters like log_connections (improved logging granularity) and security-focused extensions like pgaudit. However, no specific vulnerabilities or security patches are explicitly mentioned. The pg_tle updates relate to Trusted Language Extensions security framework, qualifying as security documentation additions.
Diff
diff --git a/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-versions.md b/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-versions.md index 0b50563a4..cc89b78da 100644 --- a//AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-versions.md +++ b//AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-versions.md @@ -50,0 +51,2 @@ To learn more about versioning policy for RDS for PostgreSQL, see [Amazon RDS FA + * PostgreSQL version 18.1 on Amazon RDS + @@ -63,0 +66,56 @@ To learn more about versioning policy for RDS for PostgreSQL, see [Amazon RDS FA +### PostgreSQL version 18.1 on Amazon RDS + +PostgreSQL 18 contains many new features and enhancements that can be seen in the following release documentation, [PostgreSQL 18](https://www.postgresql.org/docs/18/release-18.html). + +The following parameters were updated: + + * track_cost_delay_timing default is set to on + + * max_active_replication_origins default is set to 20. + + * pclient_connection_check_interval default is set to 60000. + + * log_connections was updated to reflect the new PostgreSQL 18 behavior. The old default value of 0 is equivalent to the new default empty value, and the old value of 1 is equivalent to specifying all three values of receipt, authentication, and authorization. + + * autovacuum_worker_slots,io_workers,io_max_concurrency + + + + +The following extensions were added: + + * pgcollection + + * roaringbitmap + + + + +This version also includes the following extension changes: + + * The `pgaudit` updated to version 18.0 + + * The `pg_cron` updated to version 1.6.7 + + * The `pgvector` updated to version 0.8.1 + + * The `pg_tle` updated to version 1.5.2 + + * The `mysql_fdw` updated to version 2.9.3. + + * The `tds_fdw` updated to version 2.0.5. + + + + +The following extension supported in RDS for PostgreSQL version 17 isn't supported for RDS for PostgreSQL version 18: + + * `postgis_topology` + + * `plrust` + + + + +For version information on all extensions, see [Extensions supported for RDS for PostgreSQL 18](./postgresql-extensions.html#postgresql-extensions-18x). + @@ -391,0 +450,2 @@ For version information on all extensions, see [Extensions supported for RDS for + * PostgreSQL version 17.7 on Amazon RDS + @@ -424,0 +485,20 @@ For version information on all extensions, see [Extensions supported for RDS for +### PostgreSQL version 17.7 on Amazon RDS + +PostgreSQL version 17.7 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the [PostgreSQL 17.7 release](https://www.postgresql.org/docs/release/17.7/). + +**General enhancements** + + * The pgcollection extension is now available for RDS PostgreSQL version 15.15 and above(16.11 and 17.7), providing a memory-optimized data type designed for high-performance use inside PL/pgSQL functions. A collection stores key-value pairs where each key is a unique text string (maximum 32,767 characters) and values can be any PostgreSQL type including composite types, with all elements in a collection required to be of the same type. Collections maintain entries in creation order and can hold an unlimited number of elements constrained only by available database memory, with a maximum persisted size of 1GB when stored as a table column.. + + + + +This version also includes the following extension changes: + + * The `pg_tle` extension was updated to version 1.5.2. + + * The `h3-pg` extension was updated to version 4.2.3. + + + + @@ -876,0 +957,2 @@ For version information on all extensions, see [Extensions supported for RDS for + * PostgreSQL version 16.11 on Amazon RDS + @@ -933,0 +1016,20 @@ For version information on all extensions, see [Extensions supported for RDS for +### PostgreSQL version 16.11 on Amazon RDS + +PostgreSQL version 16.11 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the [PostgreSQL 16.11 release](https://www.postgresql.org/docs/release/16.11/). + +**General enhancements** + + * The pgcollection extension is now available for RDS PostgreSQL version 15.15 and above(16.11 and 17.7), providing a memory-optimized data type designed for high-performance use inside PL/pgSQL functions. A collection stores key-value pairs where each key is a unique text string (maximum 32,767 characters) and values can be any PostgreSQL type including composite types, with all elements in a collection required to be of the same type. Collections maintain entries in creation order and can hold an unlimited number of elements constrained only by available database memory, with a maximum persisted size of 1GB when stored as a table column.. + + + + +This version also includes the following extension changes: + + * The `pg_tle` extension was updated to version 1.5.2. + + * The `h3-pg` extension was updated to version 4.2.3. + + + + @@ -1580,0 +1683,2 @@ For version information on all extensions, see [Extensions supported for RDS for + * PostgreSQL version 15.15 on Amazon RDS + @@ -1641,0 +1746,20 @@ For version information on all extensions, see [Extensions supported for RDS for +### PostgreSQL version 15.15 on Amazon RDS + +PostgreSQL version 15.15 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the [PostgreSQL 15.15 release](https://www.postgresql.org/docs/release/15.15/). + +**General enhancements** + + * The pgcollection extension is now available for RDS PostgreSQL version 15.15 and above(16.11 and 17.7), providing a memory-optimized data type designed for high-performance use inside PL/pgSQL functions. A collection stores key-value pairs where each key is a unique text string (maximum 32,767 characters) and values can be any PostgreSQL type including composite types, with all elements in a collection required to be of the same type. Collections maintain entries in creation order and can hold an unlimited number of elements constrained only by available database memory, with a maximum persisted size of 1GB when stored as a table column. + + + + +This version also includes the following extension changes: + + * The `pg_tle` extension was updated to version 1.5.2. + + * The `h3-pg` extension was updated to version 4.2.3. + + + + @@ -2331,0 +2456,2 @@ For version information on all extensions, see [Extensions supported for RDS for + * PostgreSQL version 14.20 on Amazon RDS + @@ -2402,0 +2529,15 @@ For version information on all extensions, see [Extensions supported for RDS for +### PostgreSQL version 14.20 on Amazon RDS + +PostgreSQL version 14.20 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the [PostgreSQL 14.20 release](https://www.postgresql.org/docs/release/14.20/). + +**General enhancements** + +This version also includes the following extension changes: + + * The `pg_tle` extension was updated to version 1.5.2. + + * The `h3-pg` extension was updated to version 4.2.3. + + + + @@ -3190,0 +3332,2 @@ For information on all extensions, see [Extensions supported for RDS for Postgre + * PostgreSQL version 13.23 on Amazon RDS + @@ -3267,0 +3411,15 @@ For information on all extensions, see [Extensions supported for RDS for Postgre +### PostgreSQL version 13.23 on Amazon RDS + +PostgreSQL version 13.23 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the [PostgreSQL 13.23 release](https://www.postgresql.org/docs/release/13.23/). + +**General enhancements** + +This version also includes the following extension changes: + + * The `pg_tle` extension was updated to version 1.5.2. + + * The `h3-pg` extension was updated to version 4.2.3. + + + +