Amazon RDS for PostgreSQL updates

• mysql_fdw

• pg_bigm

• pg_transport

• tds_fdw

• address_standardizer

• address_standardizer_data_us

• h3-pg

• pg_hint_plan

• pg_similarity

• pg_stat_monitor

• pgactive

• pgrouting

• plprofiler

• postgis

• postgis_raster

• postgis_tiger_geocoder

• postgis_topology

• ssl_groups default is set to X25519MLKEM768:SecP256r1MLKEM768:SecP384r1MLKEM1024:X25519:prime256v1:secp384r1

• io_min_workers

• io_max_workers

• io_worker_idle_timeout

• io_worker_launch_interval

• The pgaudit extension was updated to version 19.

• address_standardizer

• address_standardizer_data_us

• h3-pg

• mysql_fdw

• pg_bigm

• pg_hint_plan

• pg_similarity

• pg_stat_monitor

• pg_transport

• pgactive

• pgrouting

• plprofiler

• postgis

• postgis_raster

• postgis_tiger_geocoder

• postgis_topology

• tds_fdw

• autovacuum_analyze_score_weight

• autovacuum_freeze_score_weight

• autovacuum_max_parallel_workers

• autovacuum_multixact_freeze_score_weight

• autovacuum_vacuum_insert_score_weight

• autovacuum_vacuum_score_weight

• debug_print_raw_parse

• enable_eager_aggregate

• log_autoanalyze_min_duration

• max_repack_replication_slots

• min_eager_agg_group_size

• password_expiration_warning_threshold

• wal_sender_shutdown_timeout

• pg_plan_advice

• The orafce extension was updated to version 4.16.5.

• address_standardizer

• address_standardizer_data_us

• h3-pg

• h3_postgis

• hypopg

• ip4r

• mysql_fdw

• pg_bigm

• pg_cron

• pg_hint_plan

• pg_partman

• pg_similarity

• pg_stat_monitor

• pgactive

• pgAudit

• pgrouting

• plprofiler

• plv8

• PostGIS

• postgis_raster

• postgis_tiger_geocoder

• tds_fdw

• This release also updates the SSL/TLS cryptographic library to AWS-LC-FIPS 2025 on the GitHub website.

• The pglogical extension was updated to version 2.4.8.

• Fixed pgactive extension unavailability issue during TRUNCATE operations.

• Enabled SET for the parameter 'plv8.memory_limit'.

• The pgactive extension was updated to version 2.1.8.

• The PostGIS extension was updated to version 3.6.3, and the following dependencies were updated:

  • Added support for postgis_topology.

  • PROJ_DATA was updated to version 1.24.

  • GEOS was updated to 3.14.1.

  • GDAL was updated to 3.11.5.

• The pg_partman extension was updated to version 5.4.3.

• The pgcollection extension was updated to version 1.1.1.

• The pgvector extension was updated to version 0.8.2.

• The pgtap extension was updated to version 1.3.4.

• The postgis extension was updated to version 3.6.3.

• Improved stability and reliability for database operations.

• Enhanced data collection capabilities.

• Advanced query performance monitoring: Introduced the pg_stat_monitor extension for PostgreSQL 18.2 and higher to provide comprehensive query performance insights and help identify performance bottlenecks. For extension availability by version, see Extension versions for Amazon RDS for PostgreSQL.

The following extension was added:

• pg_stat_monitor

• The pgactive extension was updated to version 2.1.7.

• The pglogical extension was updated to version 2.4.6.

• The pg_hint_plan extension was updated to version 1.6.2.

• The orafce extension was updated to version 4.16.3.

• The postgis extension was updated to version 3.6.1.

• The pg_bigm extension was updated to version 1.2-20250903.

• The pg_cron extension was updated to version 1.6.7.

• The hypopg extension was updated to version 1.4.2.

• The tds_fdw extension was updated to version 2.0.5.

• The pg_repack extension was updated to version 1.5.3.

• The pgvector extension was updated to version 0.8.1.

• The mysql_fdw extension was updated to version 2.9.3.

• The oracle_fdw extension was updated to version 2.8.0.

• The roaringbitmap extension was updated to version 1.1.0.

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.

• postgis_topology

• plcoffee – The open source plv8 version 3.2 no longer includes the plcoffee and plls extensions.

• plls – The open source plv8 version 3.2 no longer includes the plcoffee and plls extensions.

• plrust – This extension is permanently discontinued and will not be available in any future version.

The following extensions were added:

• pglogical

• postgis

• pgrouting

• h3-pg

This version also includes the following extension changes:

• The pg_bigm extension was updated to version v1.2-20250903

• pgAudit

• plrust

• pg_hint_plan

• tds_fdw

• pg_transport

• The hypopg extension was updated to version 1.4.2

• The pg_repack extension was updated to version 1.5.2

• The pgactive extension was updated to version 2.1.6

• address_standardizer

• address_standardizer_data_us

• h3-pg

• pgAudit

• pglogical

• pgrouting

• plrust

• PostGIS

• postgis_raster

• postgis_tiger_geocoder

• postgis_topology

• 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

• plv8

• pgactive

• 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

• pg_overexplain

• pg_tap

• oracle_fdw

• pg_bigm

• pg_partman

• pg_proctab

• pg_repack

• pg_tle

• rdkit

• address_standardizer

• address_standardizer_data_us

• h3-pg

• pg_hint_plan

• pg_transport

• pgactive

• pgAudit

• pglogical

• pgrouting

• plrust

• plv8

• PostGIS

• postgis_raster

• postgis_tiger_geocoder

• postgis_topology

• tds_fdw

• LLVM version updated to 20.1.1

• LZ4 version updated to 1.10.0

• Zstd version updated to 1.5.7

• Zlib version updated to 1.3.1

• AWS-LC version updated to AWS-LC FIPS 3.0

• Kerberos version updated to 1.21.3

• Perl version updated to 5.40.2

• ossp-uuid now uses the e2fs UUID implementation

• address_standardizer

• address_standardizer_data_us

• h3-pg

• oracle_fdw

• pg_bigm

• pg_hint_plan

• pg_partman

• pg_proctab

• pg_repack

• pg_tle

• pg_transport

• pgactive

• pgAudit

• pglogical

• pgrouting

• pgTAP

• plrust

• pltcl

• plv8

• PostGIS

• postgis_raster

• postgis_tiger_geocoder

• postgis_topology

• rdkit

• tds_fdw

• This release also updates the SSL/TLS cryptographic library to AWS-LC-FIPS 2025 on the GitHub website.

• The pglogical extension was updated to version 2.4.8.

• Fixed pgactive extension unavailability issue during TRUNCATE operations.

• Enabled SET for the parameter 'plv8.memory_limit'.

• The pgactive extension was updated to version 2.1.8.

• The PostGIS extension was updated to version 3.5.6, and the following dependencies were updated:

  • PROJ_DATA was updated to version 1.24.

• The pg_partman extension was updated to version 5.4.3.

• The pgcollection extension was updated to version 1.1.1.

• The pgvector extension was updated to version 0.8.2.

• The pgtap extension was updated to version 1.3.4.

• The postgis extension was updated to version 3.5.6.

• Improved stability and reliability for database operations.

• Enhanced data collection capabilities.

• The pgactive extension was updated to version 2.1.7.

• The pglogical extension was updated to version 2.4.6.

• The pg_hint_plan extension was updated to version 1.7.1.

• The orafce extension was updated to version 4.16.3.

• The pg_bigm extension was updated to version 1.2-20250903.

• The pg_cron extension was updated to version 1.6.7.

• The hypopg extension was updated to version 1.4.2.

• The tds_fdw extension was updated to version 2.0.5.

• The pg_repack extension was updated to version 1.5.3.

• The pgvector extension was updated to version 0.8.1.

• The mysql_fdw extension was updated to version 2.9.3.

• The oracle_fdw extension was updated to version 2.8.0.

• 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..

• The pg_tle extension was updated to version 1.5.2.

• The h3-pg extension was updated to version 4.2.3.

• The pgactive extension was updated to version 2.1.6.

• 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.

• 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.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

• The pgactive extension was updated to version 2.1.6.

• Fixed for the address_standardizer_data_us extension issue regarding ALTER EXTENSION UPDATE failure.

• Changed the Oracle client library version for the oracle_fdw extension on x86 to 19.26.0.0.0.

• Fixed the pgactive extension unable to upgrade issue due to incorrect extension upgrade scripts which causes replication to break after engine upgrade.

• The pg_repack extension was updated to version 1.5.1.

• The pglogical extension was updated to version 2.4.5.

• The PgAudit extension was updated to version 17.1.

• The RDKit extension was updated to version 2024_09_6.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

• The pgactive extension was updated to version 2.1.6.

• In Blue/Green deployments, creating or modifying temporary objects is no longer classified as restricted DDL.

• The postgres_get_av_diag function has been updated to support radix tree optimization on PostgreSQL 17. Recommendations are now tailored to account for this new optimization feature.

• Resolved an issue where DVB returned duplicate rows during slow vacuum analysis.

• Resolved CVE RUSTSEC-2024-0421 by upgrading URL Rust crate to 2.5.4. For more information, see RUSTSEC-2024-0421.

• Applied Promise.any error allocation fix for V8 9.7.37, PLV8 3.1.10.

• The rds_tools extension was updated to 1.9.

• The orafce extension was updated to 4.14.0.

• The pg_cron extension was updated to 1.6.5.

• The rdkit extension was updated to 2024_09_3.

• The pg_active extension was updated to 2.1.4.

• The pg_partman extension was updated to 5.2.4.

• The prefix extension was updated to 1.2.10.

• The PostGIS extension was updated to 3.5.1.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

New features

• Starting in RDS for PostgreSQL versions 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21, some connection slots are reserved for the new rds_reserved role, which is granted to Amazon RDS administrative users. The number of reserved connection slots is determined by the rds.rds_reserved_connections parameter. You may need to adjust the value of the max_connections parameter to account for the number of Amazon RDS reserved connection slots.

  The rds_reserved role is a new predefined role created by Amazon RDS. Predefined roles and their privileges can't be changed. You can't drop, rename, or modify privileges for these predefined roles. Attempting to modify a predefined role results in an error.

• Added vacuum blocker detection to improve autovacuum monitoring. For more information, see Identify and resolve aggressive vacuum blockers in RDS for PostgreSQL

• Unblocked ALTER TEMP TABLE and DROP TEMP TABLE in Blue/Green replication.

• Added the rds_tools.pg_ls_multixactdir() function for pg_multixact to monitor the directory disk space usage.

• Added support for plrust version 1.2.7.

Updated features

• PostGIS was updated to version 3.5.0, and the following dependencies were updated:

  • json-c was updated to version 0.18_20240915.

  • GDAL was updated to version 3.9.3

  • PROJ was updated to version 9.5.0

  • PROJ_DATA was updated to version 1.19

• The orafce extension was updated to version 4.13.4.

• The pg_bigm extension was updated to version 1.2_20240606.

• The pg_proctab extension was updated to version 0.0.12.

• The pg_repack extension was updated to version 1.5.1.

• The pgrouting extension was updated to version 3.6.3.

• The pgvector extension was updated to version 0.8.0.

• The rdkit extension was updated to version 2024_09_2(4.6.1).

• The rds_tools extension was updated to version 1.8.

New features

• GCC was upgraded to version 12.4.0

• Introduced a new Amazon RDS-specific parameter, rds.logical_slot_sync_dbname, to specify the dbname for the PostgreSQL version 17 logical slots synchronization and failover feature.For more information, see Managing logical slot synchronization for RDS for PostgreSQL.

This version also includes the following extension and dependency updates:

• The following PostGIS dependencies were updated:

  • gdal was upgraded to version 3.9.2

  • PROJ was upgraded to version 9.4.1

  • PROJ_DATA was upgraded to version 1.18

  • GEOS was upgraded to version 3.13.0

• The oracle_fdw extension was updated to version 2.7.0.

• The orafce extension was updated to version 4.12.0.

• The pg_buffercache extension was updated to version 1.5.

• The pg_cron extension was updated to version 1.6.4.

• The pg_stat_statements extension was updated to version 1.11.

• The pgaudit extension was updated to version 17.0.

• The pgvector extension was updated to version 0.7.4.

• The plprofiler extension was updated to version 4.2.5.

• The rds_tools extension was updated to version 1.6.

• The tds_fdw extension was updated to version 2.0.4.

• plrust

New features

• Performance Insights is supported in the preview environment.

New extensions

• The pg_logical extension was added.

This version also includes the following extension updates:

• The address_standardizer extension was updated to version 3.5.0alpha2.

• The address_standardizer_data_us extension was updated to version 3.5.0alpha2.

• The PostGIS extension was updated to version 3.5.0alpha2.

• The postgis_raster extension was updated to version 3.5.0alpha2.

• The postgis_tiger_geocoder extension was updated to version 3.5.0alpha2.

• The postgis_topology extension was updated to version 3.5.0alpha2.

• plrust

New features

• The t4g instance type is supported in the Preview environment.

• The wal_compression default value for TAZ cluster is now lz4 instead of zstd.

New extensions

• The pg_hint_plan extension was added.

• The plv8 extension was added.

• The rdkit extension was added.

This version also includes the following extension updates:

• The orafce extension was updated to version 4.10.3.

• The pg_cron extension was updated to version 1.6.3.

• The pg_vector extension was updated to version 0.7.3.

• pglogical

• plrust

New extensions

• The h3-pg extension was added.

• The mysql_fdw extension was added.

• The pg_cron extension was added.

• The pgactive extension was added.

• The pgAudit extension was added.

• The pg_repack extension was added.

• The tds_fdw extension was added.

This version also includes the following extension update:

• The pgTAP extension was updated to version 1.3.3.

• pg_hint_plan

• pglogical

• plrust

• plv8

• rdkit

• h3pg

• MySQL_FDW

• pg_cron

• pg_repack

• pgactive

• pgaudit

• pghintplan

• pglogical

• plrust

• plv8

• rdkit

• tds_fdw

• This release also updates the SSL/TLS cryptographic library to AWS-LC-FIPS 2025 on the GitHub website.

• The pglogical extension was updated to version 2.4.8.

• Fixed pgactive extension unavailability issue during TRUNCATE operations.

• Enabled SET for the parameter 'plv8.memory_limit'.

• Added support for auto_explain Configuration Parameters (auto_explain.log_wal, auto_explain.log_settings, auto_explain.log_level) in Amazon RDS PostgreSQL version 16 DB parameter groups.

• The pgactive extension was updated to version 2.1.8.

• The PostGIS extension was updated to version 3.4.6, and the following dependencies were updated:

  • PROJ_DATA was updated to version 1.24.

• The pg_partman extension was updated to version 5.4.3.

• The pgcollection extension was updated to version 1.1.1.

• The pgvector extension was updated to version 0.8.2.

• The pgtap extension was updated to version 1.3.4.

• The postgis extension was updated to version 3.4.6.

• Improved stability and reliability for database operations.

• Enhanced data collection capabilities.

• The pgactive extension was updated to version 2.1.7.

• The pglogical extension was updated to version 2.4.6.

• The pg_hint_plan extension was updated to version 1.6.2.

• The orafce extension was updated to version 4.16.3.

• The pg_bigm extension was updated to version 1.2-20250903.

• The pg_cron extension was updated to version 1.6.7.

• The hypopg extension was updated to version 1.4.2.

• The tds_fdw extension was updated to version 2.0.5.

• The pg_repack extension was updated to version 1.5.3.

• The pgvector extension was updated to version 0.8.1.

• The mysql_fdw extension was updated to version 2.9.3.

• The oracle_fdw extension was updated to version 2.8.0.

• 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..

• The pg_tle extension was updated to version 1.5.2.

• The h3-pg extension was updated to version 4.2.3.

• The pgactive extension was updated to version 2.1.6.

• 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.

• 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.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

• The pgactive extension was updated to version 2.1.6.

• Fixed for the address_standardizer_data_us extension issue regarding ALTER EXTENSION UPDATE failure.

• Changed the Oracle client library version on x86 to 19.26.0.0.0.

• Fixed the pgactive extension unable to upgrade issue due to incorrect extension upgrade scripts which causes replication to break after engine upgrade.

• The pg_repack extension was updated to version 1.5.1.

• The pglogical extension was updated to version 2.4.5.

• The PgAudit extension was updated to version 16.1.

• The RDKit extension was updated to version 2024_09_6.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

• The pgactive extension was updated to version 2.1.6.

• In Blue/Green deployments, creating or modifying temporary objects is no longer classified as restricted DDL.

• Resolved an issue where DVB returned duplicate rows during slow vacuum analysis.

• Resolved CVE RUSTSEC-2024-0421 by upgrading URL Rust crate to 2.5.4. For more information, see RUSTSEC-2024-0421.

• Applied Promise.any error allocation fix for V8 9.7.37, PLV8 3.1.10.

• The rds_tools extension was updated to 1.9.

• The orafce extension was updated to 4.14.0.

• The pg_cron extension was updated to 1.6.5.

• The rdkit extension was updated to 2024_09_3.

• The pg_active extension was updated to 2.1.4.

• The pg_partman extension was updated to 5.2.4.

• The prefix extension was updated to 1.2.10.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

New features

• Starting in RDS for PostgreSQL versions 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21, some connection slots are reserved for the new rds_reserved role, which is granted to Amazon RDS administrative users. The number of reserved connection slots is determined by the rds.rds_reserved_connections parameter . You may need to adjust the value of the max_connections parameter to account for the number of Amazon RDS reserved connection slots.

  The rds_reserved role is a new predefined role created by Amazon RDS. Predefined roles and their privileges can't be changed. You can't drop, rename, or modify privileges for these predefined roles. Attempting to modify a predefined role results in an error.

• Unblocked ALTER TEMP TABLE and DROP TEMP TABLE in Blue/Green replication.

• Added the rds_tools.pg_ls_multixactdir() function for pg_multixact to monitor the directory disk space usage.

Updated features

• The oracle_fdw extension was updated to version 2.7.0.

• The orafce extension was updated to version 4.13.4.

• The pg_cron extension was updated to version 1.6.4.

• The pg_hint_plan extension was updated to version 1.6.1.

• The pgvector extension was updated to version 0.8.0.

• The plprofiler extension was updated to version 4.2.5.

• The PostGIS extension was updated to version 3.4.3.

• The rdkit extension was updated to version 4.6.1.

• The rds_tools extension was updated to version 1.7.

• The tds_fdw extension was updated to version 2.0.4.

• Delegated extension role was added.

• Fixed CVE-2024-7348 that prevents search path restrictions bypass through pattern-matching queries in information_schema.

• The hypopg extension was updated to 1.4.1.

• The mysql_fdw extension was updated to 2.9.2.

• The orafce extension was updated to 4.10.3.

• The pg_cron extension was updated to 1.6.3.

• The pgTAP extension was updated to 1.3.3.

• The pgvector extension was updated to 0.7.3.

• The rdkit extension was updated to 4.5.0 (Release 2024_03_5).

• The wal2json extension was updated to 2.6.

• Includes support for four new crates in PL/Rust, including:

  • regex

  • serde

  • serde_json

  • url

• Fixed a security issue in pg_repack

• Fixed a performance issue in pgvector for index creation on halfvec data type

• Fixed a bug in aws_s3 causing import queries to occasionally get stuck and fail to terminate

• The blue/green deployment switchover won’t be blocked by the REFRESH MATERIALIZED VIEW statement.

• Fixed the permission denial for the CREATE DATABASE WITH OWNER statement.

• Upgraded the aws_s3 extension to version 1.2 to support the export to S3 with the KMS customer managed key.

• Fixed a pgvector compatibility issue with some of the previous generations of DB instances, such as m4.

• The aws_s3 extension was updated to 1.2.

• The orafce extension was updated to 4.9.4.

• The pg_partman extension was updated to 5.1.0.

• The pgvector extension was updated to 0.7.0.

• The postgis extension was updated to 3.4.2.

• Fixed a security issue in pg_repack

• Fixed a bug allowing the querying of the security invoker views as an unprivileged user.

• Fixed a bug preventing tds_fdw from connecting when TLS is enabled.

• Fixed a bug preventing upgrades to PostGIS version 3.4.1.

• Fixed an error with the aws_s3 extension when the Region was not provided.

• The pg_partman extension was updated to 5.0.1.

• The pg_tle extension was updated to 1.4.0.

• The pgactive extension was updated to 2.1.3.

• The pgtap extension was updated to 1.3.2.

• The pgvector extension was updated to 0.6.2.

New features and enhancements

• Added support for pg_log_standby_snapshot

• Fixed the multisecond latency on the aws_lambda calls

• Fixed a bug preventing the termination of autovacuum

• Fixed a bug preventing the creation of the h3 extension

This version includes the following changes:

• The orafce extension was updated to version 4.9.0.

• The pg_repack extension was updated to version 1.5.0.

• The pgactive extension was updated to version 2.1.2.

• The pgvector extension was updated to 0.6.0.

• The plv8 extension was updated to 3.1.10.

• The PostGIS extension was updated to 3.4.1.

New features and enhancements

• Fixed a crash in CatalogCacheComputeHashValue with dblink_connect due to a Null or invalid connection

• Supported the AWS SDK version of the aws_s3 extension

• Fixed the overflow in the pg_transport extension

• Removed the unsupported shared libraries from the engine binary

This version includes the following changes:

• The plrust extension was updated to version 1.2.7.

• The plv8 extension was updated to version 3.1.9.

New features and enhancements

• The aws-lc now uses a FIPS version.

• Allow setting TLS 1.3 as the ssl_min_protocol_version and ssl_max_protocol_version.

• The pgactive extension was added.

• The pglogical extension was added.

• By default, the default_toast_compression DB instance parameter is set to lz4.

• The rds.rds_superuser_reserved_connections parameter has been deprecated in RDS for PostgreSQL version 16. The reserved_connections parameter should be utilized to reserve the number of connection slots. The reserved_connections parameter sets the number of connection slots reserved for roles with the pg_use_reserved_connections privileges. rds_superuser is a member of the pg_use_reserved_connections role by default. For more information, see the PostgreSQL documentation reserved connections.

This version includes the following changes:

• The hll extension was updated to version 2.1.8.

• The oracle_fdw extension was updated to version 2.6.0.

• The orafce extension was updated to version 4.6.1.

• The pg_cron extension was updated to version 1.6.1.

• The pg_partman extension was updated to version 5.0.0.

• The pgtap extension was updated to version 1.3.1.

• The pgvector extension was updated to version 0.5.1.

• The plprofiler extension was updated to version 4.2.4.

• The plrust extension was updated to version 1.2.6.

• The plv8 extension was updated to version 3.1.8.

• The rdkit extension was updated to version 4.4.0.

This version includes the following changes:

• The mysql_fdw extension was updated to version 2.9.1

• The pgrouting extension was updated to version 3.5.0

• The pgvector extension was updated to version 0.5.0

New extensions

• The pg_proctab extension was added.

• The rdkit extension was added.

• The hll extension was added.

• The pg_cron extension was added.

This version also includes the following change:

• The PostGIS extension was updated to version 3.4.0.

New extensions

• The h3-pg extension was added.

• The mysql_fdw extension was added.

• The oracle_fdw extension was added.

• The pg_bigm extension was added.

• The pg_hint_plan extension was added.

• The pgAudit extension was added.

• The plprofiler extension was added.

• The plrust extension was added.

• The plv8 extension was added.

This version also includes the following change:

• The pg_tle extension was updated to version 1.1.0.

New extensions

• The aws_commons extension was added.

• The aws_lambda extension was added.

• The aws_s3 extension was added.

• The hypopg extension was added.

• The orafce extension was added.

This version also includes the following change:

• pgvector was updated to version 0.4.4

• aws_commons

• aws_lambda

• aws_s3

• hll

• hypoPG

• mysql_fdw

• oracle_fdw

• orafce

• pg_bigm

• pg_cron

• pg_proctab

• pgaudit

• pghintplan

• pglogical

• plprofiler

• plrust

• plv8

• rdkit

• The pglogical extension was updated to version 2.4.8.

• Fixed performance issues on x86_64 type instances.

• Fixed pgactive extension unavailability issue during TRUNCATE operations.

• Enabled SET for the parameter 'plv8.memory_limit'.

• Added support for auto_explain Configuration Parameters (auto_explain.log_wal, auto_explain.log_settings, auto_explain.log_level) in Amazon RDS PostgreSQL version 15 DB parameter groups.

• The pgactive extension was updated to version 2.1.8.

• The PostGIS extension was updated to version 3.4.6, and the following dependencies were updated:

  • PROJ_DATA was updated to version 1.24.

• The pg_partman extension was updated to version 5.4.3.

• The pgcollection extension was updated to version 1.1.1.

• The pgvector extension was updated to version 0.8.2.

• The pgtap extension was updated to version 1.3.4.

• The postgis extension was updated to version 3.4.6.

• Improved stability and reliability for database operations.

• Enhanced data collection capabilities.

• The pgactive extension was updated to version 2.1.7.

• The pglogical extension was updated to version 2.4.6.

• The pg_hint_plan extension was updated to version 1.5.3.

• The orafce extension was updated to version 4.16.3.

• The pg_bigm extension was updated to version 1.2-20250903.

• The pg_cron extension was updated to version 1.6.7.

• The hypopg extension was updated to version 1.4.2.

• The tds_fdw extension was updated to version 2.0.5.

• The pg_repack extension was updated to version 1.5.3.

• The pgvector extension was updated to version 0.8.1.

• The mysql_fdw extension was updated to version 2.9.3.

• The oracle_fdw extension was updated to version 2.8.0.

• 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.

• The pg_tle extension was updated to version 1.5.2.

• The h3-pg extension was updated to version 4.2.3.

• The pgactive extension was updated to version 2.1.6.

• 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.

• 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.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

• The pgactive extension was updated to version 2.1.6.

• Fixed for the address_standardizer_data_us extension issue regarding ALTER EXTENSION UPDATE failure.

• Changed the Oracle client library version on x86 to 19.26.0.0.0.

• Fixed the pgactive extension unable to upgrade issue due to incorrect extension upgrade scripts which causes replication to break after engine upgrade.

• The pg_repack extension was updated to version 1.5.1.

• The pglogical extension was updated to version 2.4.5.

• The PgAudit extension was updated to version 1.7.1.

• The RDKit extension was updated to version 2024_09_6.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

• The pgactive extension was updated to version 2.1.6.

• In Blue/Green deployments, creating or modifying temporary objects is no longer classified as restricted DDL.

• Resolved an issue where DVB returned duplicate rows during slow vacuum analysis.

• Resolved CVE RUSTSEC-2024-0421 by upgrading URL Rust crate to 2.5.4. For more information, see RUSTSEC-2024-0421.

• Applied Promise.any error allocation fix for V8 9.7.37, PLV8 3.1.10.

• The rds_tools extension was updated to 1.9.

• The orafce extension was updated to 4.14.0.

• The pg_cron extension was updated to 1.6.5.

• The rdkit extension was updated to 2024_09_3.

• The pg_active extension was updated to 2.1.4.

• The pg_partman extension was updated to 5.2.4.

• The prefix extension was updated to 1.2.10.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

New features

• Starting in RDS for PostgreSQL versions 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21, some connection slots are reserved for the new rds_reserved role, which is granted to Amazon RDS administrative users. The number of reserved connection slots is determined by the rds.rds_reserved_connections parameter . You may need to adjust the value of the max_connections parameter to account for the number of Amazon RDS reserved connection slots.

  The rds_reserved role is a new predefined role created by Amazon RDS. Predefined roles and their privileges can't be changed. You can't drop, rename, or modify privileges for these predefined roles. Attempting to modify a predefined role results in an error.

• Unblocked ALTER TEMP TABLE and DROP TEMP TABLE in Blue/Green replication.

• Added the rds_tools.pg_ls_multixactdir() function for pg_multixact to monitor the directory disk space usage.

Updated features

• The oracle_fdw extension was updated to version 2.7.0.

• The orafce extension was updated to version 4.13.4.

• The pg_cron extension was updated to version 1.6.4.

• The pg_hint_plan extension was updated to version 1.5.2.

• The pgvector extension was updated to version 0.8.0.

• The plprofiler extension was updated to version 4.2.5.

• The PostGIS extension was updated to version 3.4.3.

• The rdkit extension was updated to version 4.6.1.

• The rds_tools extension was updated to version 1.7.

• The tds_fdw extension was updated to version 2.0.4.

• Delegated extension role was added.

• The hypopg extension was updated to 1.4.1.

• The mysql_fdw extension was updated to 2.9.2.

• The orafce extension was updated to 4.10.3.

• The pg_cron extension was updated to 1.6.3.

• The pgTAP extension was updated to 1.3.3.

• The pgvector extension was updated to 0.7.3.

• The rdkit extension was updated to 4.5.0 (Release 2024_03_5).

• The wal2json extension was updated to 2.6.

• Includes support for four new crates in PL/Rust, including:

  • regex

  • serde

  • serde_json

  • url

• Fixed a security issue in pg_repack

• Fixed a performance issue in pgvector for index creation on halfvec data type

• Fixed a bug in aws_s3 causing import queries to occasionally get stuck and fail to terminate

• The blue/green deployment switchover won’t be blocked by the REFRESH MATERIALIZED VIEW statement.

• Fixed the permission denial for the CREATE DATABASE WITH OWNER statement.

• Upgraded the aws_s3 extension to version 1.2 to support the export to S3 with the KMS customer managed key.

• Fixed a pgvector compatibility issue with some of the previous generations of DB instances, such as m4.

• The aws_s3 extension was updated to 1.2.

• The orafce extension was updated to 4.9.4.

• The pg_hint_plan extension was updated to 1.5.1.

• The pg_partman extension was updated to 5.1.0.

• The pgvector extension was updated to 0.7.0.

• The postgis extension was updated to 3.4.2.

• Fixed a security issue in pg_repack

• Fixed a bug allowing the querying of the security invoker views as an unprivileged user.

• Fixed a bug preventing upgrades to PostGIS version 3.4.1.

• Fixed an error with the aws_s3 extension when the Region was not provided.

• The pg_partman extension was updated to version 5.0.1.

• The pg_tle extension was updated to version 1.4.0.

• The pgactive extension was updated to version 2.1.3.

• The pgtap extension was updated to version 1.3.2.

• The pgvector extension was updated to version 0.6.2.

New features and enhancements

• Fixed the multisecond latency on the aws_lambda calls

• Fixed a bug preventing the termination of autovacuum

This version includes the following changes:

• The orafce extension was updated to version 4.9.0.

• The pgactive extension was updated to version 2.1.2.

• The pgvector extension was updated to 0.6.0.

• The plv8 extension was updated to 3.1.10.

• The PostGIS extension was updated to 3.4.1.

New features and enhancements

• Fixed a crash in CatalogCacheComputeHashValue with dblink_connect due to a Null or invalid connection.

• Backported run_as_owner to RPG 15:

  • Backported a security fix for the logical replication apply worker that allows regular table owners to obtain privilege escalation to the subscription owner (an rds_superuser). The logical apply worker mitigates the risk by temporarily switching the role from the subscription owner to the table owner during logical apply.

    In the cases of potential security breaches, the fix will break your existing logical replication if any table in the subscription is owned by a regular user, and there are security-restricted operations attached to the table via triggers or default expressions. We recommend that you carefully examine the operations attached to the table if you notice the logical replication is broken after the upgrade. If all of the operations are as expected and you wish to revert the behavior of the logical replication so your application can continue, you can do so by setting the new parameter rds.run_logical_replication_as_subscription_owner to true. Be aware that by doing so your logical replication will be vulnerable to the aforementioned security risk again.

• Added rds.run_logical_replication_as_subscription_owner to the Amazon RDS parameter group.

• Supported the AWS SDK version of the aws_s3 extension.

• Fixed the overflow in the pg_transport extension.

• Removed the unsupported shared libraries from the engine binary.

This version includes the following changes:

• The plrust extension was updated to version 1.2.7.

• The plv8 extension was updated to version 3.1.9.

New features and enhancements

• Fixed a bug where pg_database_size() with an invalid OID causes a crash.

• Added support for the rds.enable_pgactive parameter in rdsutils to avoid the warning message.

• Exposed RDKit guc param rdkit.morgan_fp_size.

• Fixed the bug where setting TABLESPACE with DEFAULT option in CREATE or ALTER DATABASE fails.

This version includes the following changes:

• The h3-pg extension was updated to version 4.1.3.

• The hll extension was updated to version 2.18.

• The oracle_fdw extension was updated to version 2.6.0.

• The orafce extension was updated to version 4.6.1.

• The pg_cron extension was updated to version 1.6.1.

• The pg_partman extension was updated to version 5.0.0.

• The pg_proctab extension was updated to version 0.0.10.

• The pgactive extension was updated to version 2.1.1.

• The pgtap extension was updated to version 1.3.1.

• The plprofiler extension was updated to version 4.2.4.

• The plrust extension was updated to version 1.2.6.

• The PostGIS extension was updated to version 3.4.0.

• The rdkit extension was updated to version 4.4.0.

• Bug and security fixes for pgactive.

• The pgvector extension was updated to version 0.5.1.

New features and enhancements

• Fixed a bug preventing database owners without the rds_superuser role from being able to create tables in the public schema.

• The pgactive extension was added.

• A new rds.cte_materialize_mode parameter was introduced which controls the materialization behavior of the query of a WITH clause, also known as a Common Table Expression. See WITH Queries for more information. The parameter values include the following:

  • default: The WITH clause will be treated using the engine's default behavior.

  • always: The full output of the query in the WITH clause will be materialized and the output reused in the outer query.

  • never: The query in the WITH clause will be inlined with the outer query if possible. This parameter will also override the MATERIALIZED and NOT MATERIALIZED keywords supplied to the WITH clause.

This version also includes the following changes:

• The mysql_fdw extension was updated to version 2.9.1.

• The pgvector extension was updated to version 0.5.0.

• The plrust extension was updated to version 1.2.5.

• The plv8 extension was updated to version 3.1.8.

• The rdkit extension was updated to version 4.3.0.

New features and enhancements

• Fixed a bug preventing users with the rds_superuser role from creating schemas in databases owned by other users.

• Users with the rds_superuser role can now access toast tables in the pg_toast schema that are owned by other users.

• Fixed an issue where ALTER TABLE took a ShareLock and may cause deadlocks.

This version also includes the following changes:

• The hypopg extension was updated to version 1.4.0.

• The orafce extension was updated to version 4.3.0.

• The pg_tle extension was updated to version 1.1.1.

• The pglogical extension was updated to version 2.4.3.

• The plrust extension was updated to version 1.2.3.

• The PostGIS extension was updated to version 3.3.3.

New features and enhancements

• Improves the performance of plrust

• Fixed a Patroni 2.1.7 restart issue and instead enables replication slot from the disk

This version also includes the following changes:

• The pgvector extension was updated to version 0.4.4.

• The plrust extension was updated to version 1.1.3.

New features and enhancements

• Includes changes to allow rds-superuser to run the pg_stat_reset_slru function

• Fixed a security issue involving rds_sec_override which wasn't reset after the intended usage, allowing unauthorized access to restricted tables

• Added the hypopg extension at version 1.3.1

• You can use logical_seed_lsn to determine the LSN at which a snapshot is taken in order to establish logical replication connection between the source and the restored target database. You can then use logical replication to continuously stream the newer data recorded after the LSN and synchronize the changes from publisher to subscriber. Specifically, it allows the customer to create a logical slot on a source RDS database, take a snapshot, restore the snapshot to a new RDS instance (target), and use the value of logical_seed_lsn() from the target instance to advance the logical slot on the source instance in order to subscribe the target to the source.

This version also includes the following changes:

• compat-collation-for-glibc was updated to version 1.8.

• libgeos was updated to version 3.11.2.

• The pg_cron extension was updated to version 1.5.2.

• The pg_partman extension was updated to version 4.7.3.

• The pg_tle extension was updated to version 1.0.4.

• The plrust extension was updated to version 1.1.1.

• The plv8 extension was updated to version 3.1.6.

• The PostGIS extension was updated to version 3.3.2.

New extensions

• The pgvector extension was added.

• The plrust extension was added.

New features and enhancements

• The archive library rds_archive is now used for archiving WAL files instead of archive_command.

• The lz4 and zstd WAL compression methods are now supported.

• By default, the default_toast_compression DB instance parameter is set to lz4.

New extensions

• The pg_walinspect extension version 1.0 was added.

This version also includes the following changes:

• The btree_gist extension was updated to version 1.7.

• The hll extension was updated to version 2.17.

• The mysql_fdw extension was updated to version 2.9.0.

• The pageinspect extension was updated to version 1.11.

• The pg_hint_plan extension was updated to version 1.5.0.

• The pg_repack extension was updated to version 1.4.8.

• The pg_stat_statements extension was updated to version 1.10.

• The pgaudit extension was updated to version 1.7.0.

• The pglogical extension was updated to version 2.4.2.

• The pgrouting extension was updated to version 3.4.1.

• The pllcoffee extension was updated to version 3.1.4.

• The plls extensionwas updated to version 3.1.4.

• The plprofiler extension was updated to version 4.2.1.

• The plv8 extension was updated to version 3.1.4.

• The PostGIS extension was updated to version 3.3.2.

• The tds_fdw extension was updated to version 2.0.3.

• The pglogical extension was updated to version 2.4.8.

• Fixed performance issues on x86_64 type instances.

• Fixed pgactive extension unavailability issue during TRUNCATE operations.

• Enabled SET for the parameter 'plv8.memory_limit'.

• Added support for auto_explain Configuration Parameters (auto_explain.log_wal, auto_explain.log_settings, auto_explain.log_level) in Amazon RDS PostgreSQL version 14 DB parameter groups.

• The pgactive extension was updated to version 2.1.8.

• The PostGIS extension was updated to version 3.4.6, and the following dependencies were updated:

  • PROJ_DATA was updated to version 1.24.

• The pg_partman extension was updated to version 5.4.3.

• The pgvector extension was updated to version 0.8.2.

• The pgtap extension was updated to version 1.3.4.

• The postgis extension was updated to version 3.4.6.

• Improved stability and reliability for database operations.

• Enhanced data collection capabilities.

• The pgactive extension was updated to version 2.1.7.

• The pglogical extension was updated to version 2.4.6.

• The pg_hint_plan extension was updated to version 1.4.4.

• The orafce extension was updated to version 4.16.3.

• The pg_bigm extension was updated to version 1.2-20250903.

• The pg_cron extension was updated to version 1.6.7.

• The hypopg extension was updated to version 1.4.2.

• The tds_fdw extension was updated to version 2.0.5.

• The pg_repack extension was updated to version 1.5.3.

• The pgvector extension was updated to version 0.8.1.

• The mysql_fdw extension was updated to version 2.9.3.

• The oracle_fdw extension was updated to version 2.8.0.

• Fixed an issue on the plv8 extension regarding CREATE EXTENSION failure on older version.

• The pg_tle extension was updated to version 1.5.2.

• The h3-pg extension was updated to version 4.2.3.

• The pgactive extension was updated to version 2.1.6.

• 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.

• 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.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

• The pgactive extension was updated to version 2.1.6.

• Fixed for the address_standardizer_data_us extension issue regarding ALTER EXTENSION UPDATE failure.

• Changed the Oracle client library version on x86 to 19.26.0.0.0.

• Fixed the pgactive extension unable to upgrade issue due to incorrect extension upgrade scripts which causes replication to break after engine upgrade.

• The pg_repack extension was updated to version 1.5.1.

• The pglogical extension was updated to version 2.4.5.

• The PgAudit extension was updated to version 1.6.3.

• The RDKit extension was updated to version 2024_09_6.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

• The pgactive extension was updated to version 2.1.6.

• In Blue/Green deployments, creating or modifying temporary objects is no longer classified as restricted DDL.

• Resolved an issue where DVB returned duplicate rows during slow vacuum analysis.

• Resolved CVE RUSTSEC-2024-0421 by upgrading URL Rust crate to 2.5.4. For more information, see RUSTSEC-2024-0421.

• Applied Promise.any error allocation fix for V8 9.7.37, PLV8 3.1.10.

• The rds_tools extension was updated to 1.9.

• The orafce extension was updated to 4.14.0.

• The pg_cron extension was updated to 1.6.5.

• The rdkit extension was updated to 2024_09_3.

• The pg_active extension was updated to 2.1.4.

• The pg_partman extension was updated to 5.2.4.

• The prefix extension was updated to 1.2.10.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

New features

• Starting in RDS for PostgreSQL versions 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21, some connection slots are reserved for the new rds_reserved role, which is granted to Amazon RDS administrative users. The number of reserved connection slots is determined by the rds.rds_reserved_connections parameter . You may need to adjust the value of the max_connections parameter to account for the number of Amazon RDS reserved connection slots.

  The rds_reserved role is a new predefined role created by Amazon RDS. Predefined roles and their privileges can't be changed. You can't drop, rename, or modify privileges for these predefined roles. Attempting to modify a predefined role results in an error.

• Unblocked ALTER TEMP TABLE and DROP TEMP TABLE in Blue/Green replication.

• Added the rds_tools.pg_ls_multixactdir() function for pg_multixact to monitor the directory disk space usage.

• Fixed potential incompatibilities in the plv8 extension occurring after database upgrades.

Updated features

• The oracle_fdw extension was updated to version 2.7.0.

• The orafce extension was updated to version 4.13.4.

• The pg_cron extension was updated to version 1.6.4.

• The pg_hint_plan extension was updated to version 1.4.3

• The pgvector extension was updated to version 0.8.0.

• The plprofiler extension was updated to version 4.2.5.

• The PostGIS extension was updated to version 3.4.3.

• The rdkit extension was updated to version 4.6.1.

• The rds_tools extension was updated to version 1.7.

• The tds_fdw extension was updated to version 2.0.4.

• Fixed potential incompatibilities in the plv8 extension occurring after database upgrades.

• Delegated extension role was added.

• The hypopg extension was updated to 1.4.1.

• The mysql_fdw extension was updated to 2.9.2.

• The orafce extension was updated to 4.10.3.

• The pg_cron extension was updated to 1.6.3.

• The pgTAP extension was updated to 1.3.3.

• The pgvector extension was updated to 0.7.3.

• The rdkit extension was updated to 4.5.0 (Release 2024_03_5).

• The wal2json extension was updated to 2.6.

• Fixed potential incompatibilities in the plv8 extension occurring after database upgrades.

• Includes support for four new crates in PL/Rust, including:

  • regex

  • serde

  • serde_json

  • url

• Fixed a security exploit issue in plv8

• Fixed a security issue in pg_repack

• Fixed a performance issue in pgvector for index creation on halfvec data type

• Fixed a bug in aws_s3 causing import queries to occasionally get stuck and fail to terminate

• The plv8 extension was updated to 3.1.10.

• The blue/green deployment switchover won’t be blocked by the REFRESH MATERIALIZED VIEW statement.

• Fixed the permission denial for the CREATE DATABASE WITH OWNER statement.

• Upgraded the aws_s3 extension to version 1.2 to support the export to S3 with the KMS customer managed key.

• Fixed a pgvector compatibility issue with some of the previous generations of DB instances, such as m4.

• The aws_s3 extension was updated to 1.2.

• The orafce extension was updated to 4.9.4.

• The pg_hint_plan extension was updated to 1.4.2.

• The pg_partman extension was updated to 5.1.0.

• The pgvector extension was updated to 0.7.0.

• The postgis extension was updated to 3.4.2.

• Fixed potential incompatibilities in the plv8 extension occurring after database upgrades.

• Fixed a security exploit issue in plv8

• Fixed a security issue in pg_repack

• The plv8 extension was updated to 3.1.10.

• Fixed a bug preventing upgrades to PostGIS version 3.4.1.

• Fixed an error with the aws_s3 extension when the Region was not provided.

• The pg_partman extension was updated to version 5.0.1.

• The pg_tle extension was updated to version 1.4.0.

• The pgactive extension was updated to version 2.1.3.

• The pgtap extension was updated to version 1.3.2.

• The pgvector extension was updated to version 0.6.2.

New features and enhancements

• Fixed the multisecond latency on the aws_lambda calls

• Fixed a bug preventing the termination of autovacuum

This version includes the following changes:

• The orafce extension was updated to version 4.9.0.

• The pg_cron extension was updated to version 1.6.2.

• The pgactive extension was updated to version 2.1.2.

• The pgvector extension was updated to 0.6.0.

• The PostGIS extension was updated to 3.4.1.

New features and enhancements

• Fixed a crash in CatalogCacheComputeHashValue with dblink_connect due to a Null or invalid connection.

• Backported run_as_owner to RPG 14

  • Backported a security fix for the logical replication apply worker that allows regular table owners to obtain privilege escalation to the subscription owner (an rds_superuser). The logical apply worker mitigates the risk by temporarily switching the role from the subscription owner to the table owner during logical apply.

    In the cases of potential security breaches, the fix will break your existing logical replication if any table in the subscription is owned by a regular user, and there are security-restricted operations attached to the table via triggers or default expressions. We recommend that you carefully examine the operations attached to the table if you notice the logical replication is broken after the upgrade. If all of the operations are as expected and you wish to revert the behavior of the logical replication so your application can continue, you can do so by setting the new parameter rds.run_logical_replication_as_subscription_owner to true. Be aware that by doing so your logical replication will be vulnerable to the aforementioned security risk again.

• Added rds.run_logical_replication_as_subscription_owner to the Amazon RDS parameter group.

• Supported the AWS SDK version of the aws_s3 extension.

• Fixed the overflow in the pg_transport extension.

• Removed the unsupported shared libraries from the engine binary.

This version includes the following change:

• The plrust extension was updated to version 1.2.7.

New features and enhancements

• Fixed a bug where pg_database_size() with an invalid OID causes a crash.

• Added support for the rds.enable_pgactive parameter in rdsutils to avoid the warning message.

• Exposed RDKit guc param rdkit.morgan_fp_size.

• Fixed the bug where setting TABLESPACE with DEFAULT option in CREATE or ALTER DATABASE fails.

• Added the pgactive extension.

This version includes the following changes:

• The h3-pg extension was updated to version 4.1.3.

• The hll extension was updated to version 2.18

• The oracle_fdw extension was updated to version 2.6.0.

• The orafce extension was updated to version 4.6.1.

• The pg_cron extension was updated to version 1.6.1.

• The pg_partman extension was updated to version 5.0.0.

• The pg_proctab extension was updated to version 0.0.10.

• The pgtap extension was updated to version 1.3.1.

• The pgvector extension was updated to version 0.5.1.

• The plprofiler extension was updated to version 4.2.4.

• The plrust extension was updated to version 1.2.6.

• The PostGIS extension was updated to version 3.4.0.

• The rdkit extension was updated to version 4.4.0.

New features and enhancements

• A new rds.cte_materialize_mode parameter was introduced which controls the materialization behavior of the query of a WITH clause, also known as a Common Table Expression. See WITH Queries for more information. The parameter values include the following:

  • default: The WITH clause will be treated using the engine's default behavior.

  • always: The full output of the query in the WITH clause will be materialized and the output reused in the outer query.

  • never: The query in the WITH clause will be inlined with the outer query if possible. This parameter will also override the MATERIALIZED and NOT MATERIALIZED keywords supplied to the WITH clause.

This version also includes the following changes:

• The pgvector extension was updated to version 0.5.0.

• The plrust extension was updated to version 1.2.5.

• The rdkit extension was updated to version 4.3.0.

New features and enhancements

• A bug was fixed preventing users with the rds_superuser role from creating schemas in databases owned by other users.

• Users with the rds_superuser role can now access toast tables in the pg_toast schema that are owned by other users.

• Fixed an issue where ALTER TABLE took a ShareLock and may cause deadlocks.

This version also includes the following changes:

• The hypopg extension was updated to version 1.4.0.

• The orafce extension was updated to version 4.3.0.

• The pg_tle extension was updated to version 1.1.1.

• The pglogical extension was updated to version 2.4.3.

• The plrust extension was added at version 1.2.3.

• The PostGIS extension was updated to version 3.3.3

New features and enhancements

• Fixed a Patroni 2.1.7 restart issue and instead enables replication slot from the disk

This version also includes the following change:

• The pgvector extension was updated to version 0.4.4.

New features and enhancements

• Includes changes to allow rds-superuser to run the pg_stat_reset_slru function

• Fixed a security issue involving rds_sec_override which wasn't reset after the intended usage, allowing unauthorized access to restricted tables

• Added extension hypopg version 1.3.1

• Added extension pgvector version 0.4.1

• You can use logical_seed_lsn to determine the LSN at which a snapshot is taken in order to establish logical replication connection between the source and the restored target database. You can then use logical replication to continuously stream the newer data recorded after the LSN and synchronize the changes from publisher to subscriber. Specifically, it allows the customer to create a logical slot on a source RDS database, take a snapshot, restore the snapshot to a new RDS instance (target), and use the value of logical_seed_lsn() from the target instance to advance the logical slot on the source instance in order to subscribe the target to the source.

This version also includes the following changes:

• compat-collation-for-glibc was updated to version 1.8.

• The pg_cron extension was updated to version 1.5.2.

• The pg_tle extension was updated to version 1.0.4.

• The pglogical extension was updated to version 2.4.2.

• The PostGIS extension was updated to version 3.3.2.

New features and enhancements

• PostgreSQL version 14.6 added support for the tcn ("triggered change notification") extension which generates notification events on table changes via a trigger function called triggered_change_notification. The tcn extension is useful for applications using drivers which support asynchronous notification. This makes it possible to notify all clients if the contents of a table have been changed, enabling them to take appropriate action in near-real time, such as updating a table cache or information display.

  However, such functionality should only be used with care as it makes all data changes on the table available to all clients (including unprivileged users) through the notification events when they listen on the tcn channel. It is the user’s responsibility to avoid using tcn trigger on a table with sensitive data to avoid information leakage.

• The seg extension version 1.4 was added.

• The tcn extension version 1.0 was added.

• The orafce extension was updated to version 3.24.

• The pgaudit extension was updated to version 1.6.2.

• The pgtap extension was updated to version 1.2.0.

• The rdkit extension was updated to version 4.2.0.

• The PostGIS dependency GDAL was updated to version 3.4.3.

• The wal2json extension was updated to version 2.5.

• The aws_s3 extension was updated to version 1.1.

• The PostGIS extension was updated to version 3.1.7.

• The pg_partman extension was updated to version 4.6.2.

• The pgrouting extension was updated to version 3.2.2.

New features and enhancements

• While this release includes other fixes, a noteworthy fix included in this release is for CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY that can potentially cause silent data corruption of indexes. Amazon RDS has made the fix for the index corruption available since the release of Amazon RDS for PostgreSQL 14.3. This release does not include any RDS specific changes or extension version updates.

New features and enhancements

• This release includes Amazon RDS collations designed to help with data migration from EBCDIC-based systems. For more information, see RDS for PostgreSQL collations for EBCDIC and other mainframe migrations.

• This release includes a fix that was made available in the PostgreSQL out-of-cycle release June 16, 2022 that resolves the CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY issue. The issue affects all community PostgreSQL 14 versions prior to 14.4. For information about how to detect and remediate the issue, see PostgreSQL 14 out-of-cycle release June 16, 2022.

• Users with the rds_superuser role can now create roles for users.

• The pglogical extension was updated to version 2.4.1.

• The pg_hint_plan extension was updated to version 1.4.

• The postgresql-hllextension was updated to version 2.16.

• The mysql_fdw extension version 2.7.0 is added. For more information, see Working with MySQL databases by using the mysql_fdw extension.

• The tds_fdw extension version 2.0.2 is added. For more information, see Working with SQL Server databases by using the tds_fdw extension in the Amazon RDS User Guide.

• The pgaudit extension is updated to 1.6.1. For information about using this extension with RDS for PostgreSQL, see Logging at the session and object level with the pgaudit extension.

• The lo (large objects) module is updated to version 1.1.

• The old_snapshot extension 1.0 is added. If you set old_snapshot_threshold to a value, this extension lets you map transaction ID to a timestamp.

• The amcheck extension was updated to version 1.3.

• The btree_gist extension was updated to version 1.6.

• The cube extension was updated to version 1.5.

• The hstore extension was updated to version 1.8.

• The intarray extension was updated to version 1.5.

• The pageinspect extension was updated to version 1.9.

• The pg_cron extension was updated to version 1.4

• The pg_partman extension was updated to version 4.6.0.

• The pg_repack extension was updated to version 1.4.7.

• The pg_stat_statements extension was updated to version 1.9.

• The pg_trgm extension was updated to version 1.6.

• The pgaudit extension was updated to version 1.6.

• The pgrouting extension was updated to version 3.2.0.

• The postgres_fdw extension was updated to version 1.1.

• Fixed an issue on the plv8 extension regarding CREATE EXTENSION failure on older version.

• The pg_tle extension was updated to version 1.5.2.

• The h3-pg extension was updated to version 4.2.3.

• The pgactive extension was updated to version 2.1.6.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

• 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.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

• The pgactive extension was updated to version 2.1.6.

• Fixed for the address_standardizer_data_us extension issue regarding ALTER EXTENSION UPDATE failure.

• Changed the Oracle client library version on x86 to 19.26.0.0.0.

• Fixed the pgactive extension unable to upgrade issue due to incorrect extension upgrade scripts which causes replication to break after engine upgrade.

• The pg_repack extension was updated to version 1.5.1.

• The pglogical extension was updated to version 2.4.5.

• The PgAudit extension was updated to version 1.5.3.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

• The pgactive extension was updated to version 2.1.6.

• In Blue/Green deployments, creating or modifying temporary objects is no longer classified as restricted DDL.

• Resolved an issue where DVB returned duplicate rows during slow vacuum analysis.

• Resolved CVE RUSTSEC-2024-0421 by upgrading URL Rust crate to 2.5.4. For more information, see RUSTSEC-2024-0421.

• Applied Promise.any error allocation fix for V8 9.7.37, PLV8 3.1.10.

• The rds_tools extension was updated to 1.9.

• The orafce extension was updated to 4.14.0.

• The pg_cron extension was updated to 1.6.5.

• The pg_active extension was updated to 2.1.4.

• The prefix extension was updated to 1.2.10.

• Updated V8 engine to version 11.5.150.2 for the plv8 extension 3.1.10.

New features

• Starting in RDS for PostgreSQL versions 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21, some connection slots are reserved for the new rds_reserved role, which is granted to Amazon RDS administrative users. The number of reserved connection slots is determined by the rds.rds_reserved_connections parameter . You may need to adjust the value of the max_connections parameter to account for the number of Amazon RDS reserved connection slots.

  The rds_reserved role is a new predefined role created by Amazon RDS. Predefined roles and their privileges can't be changed. You can't drop, rename, or modify privileges for these predefined roles. Attempting to modify a predefined role results in an error.

• Unblocked ALTER TEMP TABLE and DROP TEMP TABLE in Blue/Green replication.

• Added the rds_tools.pg_ls_multixactdir() function for pg_multixact to monitor the directory disk space usage.

• Fixed potential incompatibilities in the plv8 extension occurring after database upgrades.

Updated features

• The oracle_fdw extension was updated to version 2.7.0.

• The orafce extension was updated to version 4.13.4.

• The pg_cron extension was updated to version 1.6.4.

• The pg_hint_plan extension was updated to version 1.3.10.

• The pgvector extension was updated to version 0.8.0.

• The plprofiler extension was updated to version 4.2.5.

• The PostGIS extension was updated to version 3.4.3.

• The rds_tools extension was updated to version 1.7.

• The tds_fdw extension was updated to version 2.0.4.

• Fixed potential incompatibilities in the plv8 extension occurring after database upgrades.

• Delegated extension role was added.

• The hypopg extension was updated to 1.4.1.

• The mysql_fdw extension was updated to 2.9.2.

• The orafce extension was updated to 4.10.3.

• The pg_cron extension was updated to 1.6.3.

• The pgTAP extension was updated to 1.3.3.

• The pgvector extension was updated to 0.7.3.

• The wal2json extension was updated to 2.6.

• Fixed potential incompatibilities in the plv8 extension occurring after database upgrades.

• Includes support for four new crates in PL/Rust, including:

  • regex

  • serde

  • serde_json

  • url

• Fixed a security exploit issue in plv8

• Fixed a security issue in pg_repack

• Fixed a performance issue in pgvector for index creation on halfvec data type

• Fixed a bug in aws_s3 causing import queries to occasionally get stuck and fail to terminate

• Fixed a performance issue in aws_s3 and aws_lambda

• The plv8 extension was updated to 3.1.10.

• The blue/green deployment switchover won’t be blocked by the REFRESH MATERIALIZED VIEW statement.

• Fixed the permission denial for the CREATE DATABASE WITH OWNER statement.

• Upgraded the aws_s3 extension to version 1.2 to support the export to S3 with the KMS customer managed key.

• Fixed a pgvector compatibility issue with some of the previous generations of DB instances, such as m4.

• The aws_s3 extension was updated to 1.2.

• The orafce extension was updated to 4.9.4.

• The pg_hint_plan extension was updated to 1.3.9.

• The pgvector extension was updated to 0.7.0.

• The postgis extension was updated to 3.4.2.

• Fixed potential incompatibilities in the plv8 extension occurring after database upgrades.

• Fixed a security exploit issue in plv8

• Fixed a security issue in pg_repack

• The plv8 extension was updated to 3.1.10.

• Fixed a bug preventing upgrades to PostGIS version 3.4.1.

• The pg_partman extension was updated to version 4.5.1.

• The pg_tle extension was updated to version 1.4.0.

• The pgactive extension was updated to version 2.1.3.

• The pgtap extension was updated to version 1.3.2.

• The pgvector extension was updated to version 0.6.2.

New features and enhancements

• Fixed the multisecond latency on the aws_lambda calls

• Fixed a bug preventing the termination of autovacuum

This version includes the following changes:

• The orafce extension was updated to version 4.9.0.

• The pg_cron extension was updated to version 1.6.2.

• The pgactive extension was updated to version 2.1.2.

• The pgvector extension was updated to 0.6.0.

• The PostGIS extension was updated to 3.4.1.

New features and enhancements

• Fixed a crash in CatalogCacheComputeHashValue with dblink_connect due to a Null or invalid connection.

• Backported run_as_owner to RPG 13:

  • Backported a security fix for the logical replication apply worker that allows regular table owners to obtain privilege escalation to the subscription owner (an rds_superuser). The logical apply worker mitigates the risk by temporarily switching the role from the subscription owner to the table owner during logical apply.

    In the cases of potential security breaches, the fix will break your existing logical replication if any table in the subscription is owned by a regular user, and there are security-restricted operations attached to the table via triggers or default expressions. We recommend that you carefully examine the operations attached to the table if you notice the logical replication is broken after the upgrade. If all of the operations are as expected and you wish to revert the behavior of the logical replication so your application can continue, you can do so by setting the new parameter rds.run_logical_replication_as_subscription_owner to true. Be aware that by doing so your logical replication will be vulnerable to the aforementioned security risk again.

• Added rds.run_logical_replication_as_subscription_owner to the Amazon RDS parameter group.

• Fixed the overflow in the pg_transport extension.

• Removed the unsupported shared libraries from the engine binary.

This version includes the following change:

• The plrust extension was updated to version 1.2.7.

New features and enhancements

• Fixed a bug where pg_database_size() with an invalid OID causes a crash.

• Added support for the rds.enable_pgactive parameter in rdsutils to avoid the warning message.

• Exposed RDKit guc param rdkit.morgan_fp_size.

• Fixed the bug where setting TABLESPACE with DEFAULT option in CREATE or ALTER DATABASE fails.

• Added the pgactive extension.

This version includes the following changes:

• The h3-pg extension was updated to version 4.1.3.

• The hll extension was updated to version 2.18

• The oracle_fdw extension was updated to version 2.6.0.

• The orafce extension was updated to version 4.6.1.

• The pg_cron extension was updated to version 1.6.1.

• The pg_proctab extension was updated to version 0.0.10.

• The pgtap extension was updated to version 1.3.1.

• The pgvector extension was updated to version 0.5.1.

• The plprofiler extension was updated to version 4.2.4.

• The plrust extension was updated to version 1.2.6.

• The PostGIS extension was updated to version 3.4.0.

This version includes the following change:

• The pgvector extension was updated to version 0.5.0.

• The plrust extension was updated to version 1.2.5.

New features and enhancements

• A bug was fixed preventing users with the rds_superuser role from creating schemas in databases owned by other users.

• Users with the rds_superuser role can now access toast tables in the pg_toast schema that are owned by other users.

• Fixed an issue where ALTER TABLE took a ShareLock and may cause deadlocks.

This version also includes the following changes:

• hypopg was updated to 1.4.0

• orafce was updated to 4.3.0

• pg_tle was added at version 1.1.1

• pglogical was updated to 2.4.3

• plrust was added at version 1.2.3