Amazon RDS Extended Support updates
Learn about the Amazon RDS Extended Support updates below.
Amazon RDS Extended Support for PostgreSQL 11
Minor versions
Amazon RDS Extended Support version 11.22-RDS.20240509
RDS Extended Support version 11.22-RDS.20240509 is now available.
Extensions updated:
-
The
plcoffee
extension was updated to version 3.1.6. -
The
plls
extension was updated to version 3.1.6. -
The
plv8
extension was updated to version 3.1.6.
Amazon RDS Extended Support version 11.22-RDS.20240418
RDS Extended Support version 11.22-RDS.20240418 is now available.
Bugs fixed:
-
Fixed a bug preventing the termination of autovacuum
CVEs fixed:
PostgreSQL version 11.22-R2 on Amazon RDS (Extended Support)
PostgreSQL version 11.22-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 11.22 release
New features and enhancements
-
Backported run_as_owner to RPG 11:
-
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.
PostgreSQL version 11.22 on Amazon RDS (Extended Support)
PostgreSQL version 11.22 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 11.22 release
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
withDEFAULT
option inCREATE
orALTER DATABASE
fails. -
Added the
pgactive
extension.
This version includes the following changes:
-
The
hll
extension was updated to version 2.18 -
The
orafce
extension was updated to version 4.6.1. -
The
pg_proctab
extension was updated to version 0.0.10. -
The
pgtap
extension was updated to version 1.3.1. -
The
plprofiler
extension was updated to version 4.2.4.