AWS AmazonRDS medium security documentation change
Summary
Added documentation for PostgreSQL versions 18 Beta 3, 17.6, 16.10, 15.14, 14.19, and 13.22, including new parameters, extensions, and general enhancements
Security assessment
The addition of parameters like 'idle_replication_slot_timeout' (prevents resource exhaustion), 'md5_password_warnings' (deprecation warnings for weak authentication), 'log_lock_failure' (security logging), and 'restrict_nonsystem_relation_kind' (access control) in PostgreSQL 18 Beta 3 directly addresses security-related configurations. These parameters improve security posture by mitigating risks associated with idle resources, weak authentication methods, and unauthorized access.
Diff
diff --git a/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-versions.md b/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-versions.md index fc6e6930e..1e6ef5257 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 Beta 3 in the Amazon RDS Preview environment + @@ -57,0 +60,77 @@ To learn more about versioning policy for RDS for PostgreSQL, see [Amazon RDS FA +### PostgreSQL version 18 Beta 3 in the Amazon RDS Preview environment + +PostgreSQL 18 Beta 3 contains many new features and enhancements that can be seen in the release documentation: [PostgreSQL 18 Beta 3 Released!](https://www.postgresql.org/about/news/postgresql-176-1610-1514-1419-1322-and-18-beta-3-released-3118/). + +The following modifiable parameters were added: + + * `autovacuum_vacuum_max_threshold` + + * `track_cost_delay_timing` + + * `idle_replication_slot_timeout` + + * `md5_password_warnings` + + * `log_lock_failure` + + * `restrict_nonsystem_relation_kind` + + * `vacuum_truncate` + + * `vacuum_max_eager_freeze_failure_rate` + + * `enable_distinct_reordering` + + * `enable_self_join_elimination` + + * `max_active_replication_origins` + + * `io_max_combine_limit` + + + + +The following extensions were added: + + * `plv8` + + * `pgactive` + + + + +The following extensions that are supported in Amazon RDS PostgreSQL version 17 aren't supported for Amazon RDS PostgreSQL version 18 Beta 3 in preview: + + * `address_standardizer` + + * `address_standardizer_data_us` + + * `h3-pg` + + * `pg_hint_plan` + + * `pg_transport` + + * `pgAudit` + + * `pglogical` + + * `pgrouting` + + * `plrust` + + * `PostGIS` + + * `postgis_raster` + + * `postgis_tiger_geocoder` + + * `postgis_topology` + + * `tds_fdw` + + + + +For version information on all extensions, see [Extensions supported for RDS for PostgreSQL 18](./postgresql-extensions.html#postgresql-extensions-18x). + @@ -214,0 +294,2 @@ For version information on all extensions, see [Extensions supported for RDS for + * PostgreSQL version 17.6 on Amazon RDS + @@ -239,0 +321,24 @@ For version information on all extensions, see [Extensions supported for RDS for +### PostgreSQL version 17.6 on Amazon RDS + +PostgreSQL version 17.6 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the [PostgreSQL 17.6 release](https://www.postgresql.org/docs/release/17.6/). + +**General enhancements** + + * Grant rds_superuser access to pg_wal_pause / pg_wal_replay functions to perform logical upgrades and verification/validation. + + * Updated V8 engine to version 11.5.150.2 for the `plv8` extension 3.1.10. + + + + +This version also includes the following extension changes: + + * The `pg_repack` extension was updated to version 1.5.2. + + * The `oracle_fdw` extension was updated to version 2.8.0. + + * The `pgactive` extension was updated to version 2.1.5. + + + + @@ -620,0 +726,2 @@ For version information on all extensions, see [Extensions supported for RDS for + * PostgreSQL version 16.10 on Amazon RDS + @@ -669,0 +777,24 @@ For version information on all extensions, see [Extensions supported for RDS for +### PostgreSQL version 16.10 on Amazon RDS + +PostgreSQL version 16.10 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the [PostgreSQL 16.10 release](https://www.postgresql.org/docs/release/16.10/). + +**General enhancements** + + * Grant rds_superuser access to pg_wal_pause / pg_wal_replay functions to perform logical upgrades and verification/validation. + + * Updated V8 engine to version 11.5.150.2 for the `plv8` extension 3.1.10. + + + + +This version also includes the following extension changes: + + * The `pg_repack` extension was updated to version 1.5.2. + + * The `oracle_fdw` extension was updated to version 2.8.0. + + * The `pgactive` extension was updated to version 2.1.5. + + + + @@ -1245,0 +1377,2 @@ For version information on all extensions, see [Extensions supported for RDS for + * PostgreSQL version 15.14 on Amazon RDS + @@ -1298,0 +1432,24 @@ For version information on all extensions, see [Extensions supported for RDS for +### PostgreSQL version 15.14 on Amazon RDS + +PostgreSQL version 15.14 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the [PostgreSQL 15.14 release](https://www.postgresql.org/docs/release/15.14/). + +**General enhancements** + + * Grant rds_superuser access to pg_wal_pause / pg_wal_replay functions to perform logical upgrades and verification/validation. + + * Updated V8 engine to version 11.5.150.2 for the `plv8` extension 3.1.10. + + + + +This version also includes the following extension changes: + + * The `pg_repack` extension was updated to version 1.5.2. + + * The `oracle_fdw` extension was updated to version 2.8.0. + + * The `pgactive` extension was updated to version 2.1.5. + + + + @@ -1915,0 +2073,2 @@ For version information on all extensions, see [Extensions supported for RDS for + * PostgreSQL version 14.19 on Amazon RDS + @@ -1978,0 +2138,24 @@ For version information on all extensions, see [Extensions supported for RDS for +### PostgreSQL version 14.19 on Amazon RDS + +PostgreSQL version 14.19 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the [PostgreSQL 14.19 release](https://www.postgresql.org/docs/release/14.19/). + +**General enhancements** + + * Grant rds_superuser access to pg_wal_pause / pg_wal_replay functions to perform logical upgrades and verification/validation. + + * Updated V8 engine to version 11.5.150.2 for the `plv8` extension 3.1.10. + + + + +This version also includes the following extension changes: + + * The `pg_repack` extension was updated to version 1.5.2. + + * The `oracle_fdw` extension was updated to version 2.8.0. + + * The `pgactive` extension was updated to version 2.1.5. + + + + @@ -2695,0 +2879,2 @@ For information on all extensions, see [Extensions supported for RDS for Postgre + * PostgreSQL version 13.22 on Amazon RDS +