Amazon RDS Extended Support updates - Amazon Relational Database Service

Amazon RDS Extended Support updates

Learn about the Amazon RDS Extended Support updates below.

Amazon RDS Extended Support for PostgreSQL 11

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 with DEFAULT option in CREATE or ALTER 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.