Amazon RDS for PostgreSQL updates - Amazon Relational Database Service

Amazon RDS for PostgreSQL updates

Amazon RDS supports DB instances running several versions of PostgreSQL. You can specify any currently available PostgreSQL version when creating a new DB instance. You can specify the major version (such as PostgreSQL 10) and any available minor version for the specified major version. If no version is specified, Amazon RDS defaults to an available version, typically the most recent version. If a major version is specified but a minor version isn't, Amazon RDS defaults to a recent release of the major version that you specified.

To see a list of available versions, and also defaults for newly created DB instances, use the describe-db-engine-versions AWS CLI command. For example, to display the default PostgreSQL engine version, use the following command.

aws rds describe-db-engine-versions --default-only --engine postgres

To learn more about versioning policy for RDS for PostgreSQL, see Amazon RDS FAQs. For more information about PostgreSQL versions, see Versioning Policy in the PostgreSQL documentation.

PostgreSQL 16 versions

PostgreSQL version 16.2-R2 on Amazon RDS

PostgreSQL version 16.2-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 16.2 release.

New features and enhancements.

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

This version also includes the following extension changes:.

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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 16.

PostgreSQL version 16.2 on Amazon RDS

PostgreSQL version 16.2 on Amazon RDS

PostgreSQL version 16.2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 16.2 release..

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 16.

PostgreSQL version 16.1-R2 on Amazon RDS

PostgreSQL version 16.1-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 16 release..

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

  • Blocked the meta-command execution, for example, \copy, \i, and \lo_export in psql

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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 16.

PostgreSQL version 16.1 on Amazon RDS

PostgreSQL version 16.1 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 16 release..

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 16.

PostgreSQL version 16.0 in the Amazon RDS Preview environment

The preview documentation for Amazon RDS PostgreSQL version 16.0 is subject to change.

Note

RDS for PostgreSQL versions 16 RC1, 16 Beta 3, 16 Beta 2, and 16 Beta 1 will not be supported after RDS for PostgreSQL version 16.0 is released in the Preview environment.

PostgreSQL version 16.0 is now available in the Amazon RDS Preview environment. PostgreSQL version 16 contains several improvements that are described in the PostgreSQL 16 release.

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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 16.

PostgreSQL version 16 RC1 in the Amazon RDS Preview environment

This is preview documentation for Amazon RDS PostgreSQL version 16 RC1. It is subject to change.

PostgreSQL version 16 RC1 is now available in the Amazon RDS Preview environment. PostgreSQL version 16 RC1 contains several improvements that are described in the following PostgreSQL documentation: PostgreSQL 16 RC1 Released.

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 16.

PostgreSQL version 16 Beta 3 in the Amazon RDS Preview environment

This is preview documentation for Amazon RDS PostgreSQL version 16 Beta 3. It is subject to change.

PostgreSQL version 16 Beta 3 is now available in the Amazon RDS Preview environment. PostgreSQL version 16 Beta 3 contains several improvements that are described in the following PostgreSQL documentation: PostgreSQL 16 Beta 3 Released.

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 16.

PostgreSQL version 16 Beta 2 in the Amazon RDS Preview environment

This is preview documentation for Amazon RDS PostgreSQL version 16 Beta 2. It is subject to change.

PostgreSQL version 16 Beta 2 is now available in the Amazon RDS Preview environment. PostgreSQL version 16 Beta 2 contains several improvements that are described in the following PostgreSQL documentation: PostgreSQL 16 Beta 2 Released.

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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 16.

PostgreSQL version 16 Beta 1 in the Amazon RDS Preview environment

This is preview documentation for Amazon RDS PostgreSQL version 16 Beta 1. It is subject to change.

PostgreSQL version 16 Beta 1 is now available in the Amazon RDS Preview environment. PostgreSQL version 16 Beta 1 contains several improvements that are described in the following PostgreSQL documentation: PostgreSQL 16 Beta 1 Released.

The following extensions supported in Amazon RDS PostgreSQL version 15 aren't supported for Amazon RDS PostgreSQL version 16 Beta 1 in preview:

  • 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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 16.

PostgreSQL 15 versions

PostgreSQL version 15.6-R2 on Amazon RDS

PostgreSQL version 15.6-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 15.6 release.

New features and enhancements.

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

This version also includes the following extension changes:

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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 15.

PostgreSQL version 15.6 on Amazon RDS

PostgreSQL version 15.6 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 15.6 release.

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 15.

PostgreSQL version 15.5-R2 on Amazon RDS

PostgreSQL version 15.5-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 15.5 release.

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.

  • Blocked the meta-command execution, for example, \copy, \i, and \lo_export, in psql.

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

PostgreSQL version 15.5 on Amazon RDS

PostgreSQL version 15.5 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 15.5 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.

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.

PostgreSQL version 15.4-R3 on Amazon RDS

PostgreSQL version 15.4-R3 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 15.4 release.

This version includes the following changes:

  • Bug and security fixes for pgactive.

  • The pgvector extension was updated to version 0.5.1.

PostgreSQL version 15.4-R2 on Amazon RDS

PostgreSQL version 15.4-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 15.4 release.

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 15.

PostgreSQL version 15.4 on Amazon RDS

PostgreSQL version 15.4 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 15.4 release.

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 15.

PostgreSQL version 15.3-R2 on Amazon RDS

PostgreSQL version 15.3-R2 is now available on Amazon RDS. This release contains logical replication for Multi-AZ DB clusters, improved plrust performance, and an update to pgvector.

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 15.

PostgreSQL version 15.3 on Amazon RDS

PostgreSQL version 15.3 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 15.3 release.

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

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 15.

PostgreSQL version 15.2-R2 on Amazon RDS (Deprecated)

PostgreSQL version 15.2-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 15.2 release.

New extensions
  • The pgvector extension was added.

  • The plrust extension was added.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 15.

PostgreSQL version 15.2 on Amazon RDS (Deprecated)

PostgreSQL version 15.2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 15.2 release.

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 15.

PostgreSQL 14 versions

PostgreSQL version 14.11-R2 on Amazon RDS

PostgreSQL version 14.11-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.11 release.

New features and enhancements.

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

This version also includes the following extension changes:

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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.11 on Amazon RDS

PostgreSQL version 14.11 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.11 release..

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.10-R2 on Amazon RDS

PostgreSQL version 14.10-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.10 release.

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.

  • Blocked the meta-command execution, for example, \copy, \i, and \lo_export, in psql.

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

PostgreSQL version 14.10 on Amazon RDS

PostgreSQL version 14.10 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.10 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 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.

PostgreSQL version 14.9-R2 on Amazon RDS

PostgreSQL version 14.9-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.9 release.

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.9 on Amazon RDS

PostgreSQL version 14.9 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.9 release.

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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.8-R2 on Amazon RDS

PostgreSQL version 14.8-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.8 release.

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.8 on Amazon RDS

PostgreSQL version 14.8 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.8 release.

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

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.7 on Amazon RDS (Deprecated)

PostgreSQL version 14.7 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.7 release.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.6 on Amazon RDS (Deprecated)

PostgreSQL version 14.6 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.6 release.

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.

This version includes the following changes:

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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.5 on Amazon RDS (Deprecated)

PostgreSQL version 14.5 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.5 release.

This version includes the following changes:

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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.4 on Amazon RDS (Deprecated)

PostgreSQL version 14.4 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.4 release.

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.3 on Amazon RDS (Deprecated)

PostgreSQL version 14.3 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 14.3 release.

New features and enhancements

This version also includes the following changes:

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.2 on Amazon RDS (Deprecated)

PostgreSQL version 14.2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in PostgreSQL 14.2.

This version also includes the following changes:

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 14.1 on Amazon RDS (Deprecated)

PostgreSQL version 14.1 is now available on Amazon RDS. This release contains several improvements that were announced in PostgreSQL 14.1.

This version also includes the following changes:

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

For information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL 13 versions

PostgreSQL version 13.14-R2 on Amazon RDS

PostgreSQL version 13.14-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 13.14 release.

New features and enhancements

  • Fixed a bug preventing upgrades to PostGIS version 3.4.1.

This version also includes the following extension changes:

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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.14 on Amazon RDS

PostgreSQL version 13.14 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 13.14 release..

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.13-R2 on Amazon RDS

PostgreSQL version 13.13-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 13.13 release.

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.

  • Blocked the meta-command execution, for example, \copy, \i, and \lo_export, in psql.

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

PostgreSQL version 13.13 on Amazon RDS

PostgreSQL version 13.13 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 13.13 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 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.

PostgreSQL version 13.12-R2 on Amazon RDS

PostgreSQL version 13.12-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 13.12 release.

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.12 on Amazon RDS

PostgreSQL version 13.12 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 13.12 release.

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

  • PostGIS was updated to 3.3.3

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.11-R2 on Amazon RDS

PostgreSQL version 13.11-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 13.11 release.

This version also includes the following change:

  • The pgvector extension was updated to version 0.4.4.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.

PostgreSQL version 13.11 on Amazon RDS

PostgreSQL version 13.11 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 13.11 release.

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

This version also includes the following changes:

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

  • libcompat was updated to version 1.8

  • pg_cron was updated to version 1.5.2

  • pglogical was updated to version 2.4.2

  • PostGIS was updated to version 3.3.2

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.10 on Amazon RDS (Deprecated)

PostgreSQL version 13.10 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 13.10 release.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.9 on Amazon RDS (Deprecated)

PostgreSQL version 13.9 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 13.9 release.

New features and enhancements

  • PostgreSQL version 13.9 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.

This version includes the following changes:

  • The seg extension version 1.3 is added.

  • The tcn extension version 1.0 is added.

  • The orafce extension is updated to 3.24.

  • The pgaudit extension is updated to 1.5.2.

  • The pgtap extension is updated to 1.2.0.

  • The PostGIS dependency GDAL is updated to 3.4.3.

  • The PostGIS dependency PROJ is updated to 8.0.1.

  • The wal2json extension is updated to 2.5.

  • The aws_s3 extension is updated to 1.1.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.8 on Amazon RDS (Deprecated)

PostgreSQL version 13.8 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in PostgreSQL 13.8.

This version includes the following changes:

  • The PostGIS extension is updated to 3.1.7

  • The pgRouting extension is updated to 3.1.4

For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.7 on Amazon RDS (Deprecated)

PostgreSQL version 13.7 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in PostgreSQL 13.7.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.6 on Amazon RDS (Deprecated)

PostgreSQL version 13.6 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in PostgreSQL 13.6.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.5 on Amazon RDS (Deprecated)

PostgreSQL version 13.5 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in PostgreSQL 13.5.

This version also includes the following change:

  • The pg_cron extension is updated to 1.4.1

For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.4 on Amazon RDS (Deprecated)

PostgreSQL version 13.4 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in PostgreSQL 13.4.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.3 on Amazon RDS (Deprecated)

PostgreSQL version 13.3 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in PostgreSQL 13.3.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.2 on Amazon RDS (Deprecated)

PostgreSQL version 13.2 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in PostgreSQL 13.2.

This version also added the following new extensions:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL version 13.1 on Amazon RDS (Deprecated)

PostgreSQL version 13.1 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in PostgreSQL 13.0 and PostgreSQL 13.1.

This version added:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.

PostgreSQL 12 versions

PostgreSQL version 12.18-R2 on Amazon RDS

PostgreSQL version 12.18-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 12.18 release..

This version includes the following extension changes:

  • The pg_partman extension was updated to version 5.0.1.

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

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.18 on Amazon RDS

PostgreSQL version 12.18 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 12.18 release..

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.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.17-R2 on Amazon RDS

PostgreSQL version 12.17-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 12.17 release.

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 12:

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

  • Blocked the meta-command execution, for example, \copy, \i, and \lo_export, in psql.

  • Fixed the overflow in the pg_transport extension.

  • Removed the unsupported shared libraries from the engine binary.

PostgreSQL version 12.17 on Amazon RDS

PostgreSQL version 12.17 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 12.17 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 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 PostGIS extension was updated to version 3.4.0.

PostgreSQL version 12.16-R2 on Amazon RDS

PostgreSQL version 12.16-R2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 12.16 release.

New features and enhancements
  • The pgvector extension was added.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.16 on Amazon RDS

PostgreSQL version 12.16 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 12.16 release.

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 orafce extension was updated to version 4.3.0.

  • The pglogical extension was updated to version 2.4.3.

  • The PostGIS extension was updated to version 3.3.3.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.15 on Amazon RDS

PostgreSQL version 12.15 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 12.15 release.

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

This version also includes the following changes:

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

  • pg_cron was updated to version 1.5.2

  • pglogical was updated to version 2.4.2

  • PostGIS was updated to version 3.3.2

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.14 on Amazon RDS (Deprecated)

PostgreSQL version 12.14 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 12.14 release.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.13 on Amazon RDS (Deprecated)

PostgreSQL version 12.13 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 12.13 release.

New features and enhancements

  • PostgreSQL version 12.13 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.

This version includes the following changes:

  • The seg extension version 1.3 is added.

  • The tcn extension version 1.0 is added.

  • The orafce extension is updated to 3.24.

  • The pgaudit extension is updated to 1.4.3.

  • The pgtap extension is updated to 1.2.0.

  • The PostGIS dependency GDAL is updated to 3.4.3.

  • The PostGIS dependency PROJ is updated to 7.0.1.

  • The wal2json extension is updated to 2.5.

  • The aws_s3 extension is updated to 1.1.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.12 on Amazon RDS (Deprecated)

PostgreSQL version 12.12 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in PostgreSQL 12.12.

This version includes the following changes:

  • The PostGIS extension is updated to 3.1.7

  • The pgRouting extension is updated to 3.0.6

For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.11 on Amazon RDS (Deprecated)

PostgreSQL version 12.11 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in PostgreSQL 12.11.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.10 on Amazon RDS (Deprecated)

PostgreSQL version 12.10 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in 12.10.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.9 on Amazon RDS (Deprecated)

PostgreSQL version 12.9 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in 12.9.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.8 on Amazon RDS (Deprecated)

PostgreSQL version 12.8 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in 12.8.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.7 on Amazon RDS (Deprecated)

PostgreSQL version 12.7 is now available on Amazon RDS. PostgreSQL version 12.7 contains several improvements that were announced for PostgreSQL release 12.7.

This version also includes the following changes:

For information on all extensions, see PostgreSQL version 12 extensions supported on Amazon RDS in the Amazon RDS User Guide.

PostgreSQL version 12.6 on Amazon RDS (Deprecated)

PostgreSQL version 12.6 is now available on Amazon RDS. PostgreSQL version 12.6 contains several improvements that were announced for PostgreSQL release 12.6.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.5 on Amazon RDS (Deprecated)

PostgreSQL version 12.5 is now available on Amazon RDS. PostgreSQL version 12.5 contains several improvements that were announced for PostgreSQL release 12.5.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.4 on Amazon RDS (Deprecated)

PostgreSQL version 12.4 is now available on Amazon RDS. PostgreSQL version 12.4 contains several improvements that were announced for PostgreSQL release 12.4.

This version also includes the following changes:

  • Added the pg_proctab extension version 0.0.9

  • Added the rdkit extension version 3.8

  • Upgraded the aws_s3 extension to version 1.1.

  • Upgraded the pglogical extension to version 2.3.2

  • Upgraded the wal2json extension to version 2.3

For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.3 on Amazon RDS (Deprecated)

PostgreSQL version 12.3 is now available on Amazon RDS. PostgreSQL version 12.3 contains several improvements that were announced for PostgreSQL release 12.3.

This version also includes the following changes:

  • Upgraded the pg_hint_plan extension to version 1.3.5.

  • Upgraded the pglogical extension to version 2.3.1.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL version 12.2 on Amazon RDS (Deprecated)

PostgreSQL version 12.2 is now available on Amazon RDS. PostgreSQL version 12.2 contains several improvements that were announced for PostgreSQL releases 12.0, 12.1, and 12.2.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.

PostgreSQL 11 versions (Extended Support)

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.

  • Blocked the meta-command execution, for example, \copy, \i, and \lo_export, in psql.

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

PostgreSQL 11 versions (Deprecated)

PostgreSQL version 11.21 on Amazon RDS (Deprecated)

PostgreSQL version 11.21 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 11.21 release.

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 orafce extension was updated to version 4.3.0.

  • The pglogical extension was updated to version 2.4.3.

  • The PostGIS extension was updated to version 3.3.3.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.20 on Amazon RDS (Deprecated)

PostgreSQL version 11.20 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 11.20 release.

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

This version also includes the following changes:

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

  • pglogical was updated to version 2.4.2

  • PostGIS was updated to version 3.3.2

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.19 on Amazon RDS (Deprecated)

PostgreSQL version 11.19 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 11.19 release.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.18 on Amazon RDS (Deprecated)

PostgreSQL version 11.18 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 11.18 release.

New features and enhancements

  • PostgreSQL version 11.18 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.

This version includes the following changes:

  • The seg extension version 1.3 is added.

  • The tcn extension version 1.0 is added.

  • The orafce extension is updated to 3.24.

  • The pgaudit extension is updated to 1.3.4.

  • The pgtap extension is updated to 1.2.0.

  • The PostGIS dependency GDAL is updated to 3.4.3.

  • The PostGIS dependency PROJ is updated to 7.0.1.

  • The wal2json extension is updated to 2.5.

  • The aws_s3 extension is updated to 1.1.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.17 on Amazon RDS (Deprecated)

PostgreSQL version 11.17 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in PostgreSQL 11.17.

This version includes the following change:

  • The PostGIS extension is updated to 3.1.7

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.16 on Amazon RDS (Deprecated)

PostgreSQL version 11.16 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in PostgreSQL 11.16.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.15 on Amazon RDS (Deprecated)

PostgreSQL version 11.15 is now available on Amazon RDS. PostgreSQL version 11.15 contains several improvements that were announced for PostgreSQL release 11.15.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.14 on Amazon RDS (Deprecated)

PostgreSQL version 11.14 is now available on Amazon RDS. PostgreSQL version 11.14 contains several improvements that were announced for PostgreSQL release 11.14.

This version also includes the following change:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.13 on Amazon RDS (Deprecated)

PostgreSQL version 11.13 is now available on Amazon RDS. PostgreSQL version 11.13 contains several improvements that were announced for PostgreSQL release 11.13.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.12 on Amazon RDS (Deprecated)

PostgreSQL version 11.12 is now available on Amazon RDS. PostgreSQL version 11.12 contains several improvements that were announced for PostgreSQL release 11.12.

This version also includes the following change:

  • The orafce extension is updated to version 3.15.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.11 on Amazon RDS (Deprecated)

PostgreSQL version 11.11 is now available on Amazon RDS. PostgreSQL version 11.11 contains several improvements that were announced for PostgreSQL release 11.11.

This version also added the following new extension:

  • The pg_bigm extension version 1.2.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.10 on Amazon RDS (Deprecated)

PostgreSQL version 11.10 is now available on Amazon RDS. PostgreSQL version 11.10 contains several improvements that were announced for PostgreSQL release 11.10.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.9 on Amazon RDS (Deprecated)

PostgreSQL version 11.9 is now available on Amazon RDS. PostgreSQL version 11.9 contains several improvements that were announced for PostgreSQL release 11.9.

This version also includes the following changes:

  • Added the aws_s3 extension version 1.1

  • Added the pg_proctab extension version 0.0.9

  • Upgraded the pgaudit extension to version 1.3.1

  • Upgraded the pglogical extension to version 2.2.2

  • Added the rdkit extension version 3.8

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.8 on Amazon RDS (Deprecated)

PostgreSQL version 11.8 contains several bug fixes for issues in release 11.7. For more information on the fixes in PostgreSQL 11.8, see the PostgreSQL 11.8 documentation.

This version also includes the following change:

  • Upgraded the pg_hint_plan extension to version 1.3.5.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.7 on Amazon RDS (Deprecated)

PostgreSQL version 11.7 contains several bug fixes for issues in release 11.6. For more information on the fixes in PostgreSQL 11.7, see the PostgreSQL 11.7 documentation.

PostgreSQL version 11.6 on Amazon RDS (Deprecated)

PostgreSQL version 11.6 contains several bug fixes for issues in release 11.5. For more information on the fixes in PostgreSQL 11.6, see the PostgreSQL documentation.

This version also includes the following changes:

  • Upgraded the pgTAP extension to version 1.1.0.

  • Added the plprofiler extension.

  • Added to shared_preload_libraries support for pg_prewarm to start automatically.

PostgreSQL version 11.5 on Amazon RDS (Deprecated)

PostgreSQL version 11.5 contains several bug fixes for issues in release 11.4. For more information on the fixes in PostgreSQL 11.5, see the PostgreSQL documentation.

This version also includes the following changes:

PostgreSQL version 11.4 on Amazon RDS (Deprecated)

This release contains an important security fix and also bug fixes and improvements done by the PostgreSQL community. For more information on the security fix, see the PostgreSQL community announcement and the security fix CVE-2019-10164.

With this release, the pg_hint_plan extension has been updated to version 1.3.4.

For more information on the fixes in PostgreSQL 11.4, see the PostgreSQL documentation.

PostgreSQL version 11.2 on Amazon RDS (Deprecated)

PostgreSQL version 11.2 contains several bug fixes for issues in release 11.1. For more information on the fixes in PostgreSQL 11.2, see the PostgreSQL documentation.

This version also includes the following changes:

For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL version 11.1 on Amazon RDS (Deprecated)

PostgreSQL version 11.1 contains several improvements that were announced in PostgreSQL 11.1 released! This version includes SQL stored procedures that enable embedded transactions within a procedure. This version also includes major improvements to partitioning and parallelism and many useful performance improvements. For example, by using a non-null constant for a column default, you can now use an ALTER TABLE command to add a column without causing a table rewrite.

PostgreSQL version 11.1 contains several bug fixes for issues in release 11. For complete details, see the PostgreSQL release 11.1 documentation. Some changes in this version include the following:

  • Partitioning – Partitioning improvements include support for hash partitioning, enabling creation of a default partition, and dynamic row movement to another partition based on the key column update.

  • Performance – Performance improvements include parallelism while creating indexes, materialized views, hash joins, and sequential scans to make the operations perform better.

  • Stored procedures – SQL stored procedures now added support embedded transactions.

  • Support for Just-In-Time (JIT) capability – RDS for PostgreSQL 11 instances are created with JIT capability, speeding evaluation of expressions. To enable JIT capability, set the jit parameter to 1 in the PostgreSQL parameter group for the database.

  • Segment size – The write-ahead logging (WAL) segment size has been changed from 16 MB to 64 MB.

  • Autovacuum improvements – To provide valuable logging, the parameter rds.force_autovacuum_logging is ON by default in conjunction with the log_autovacuum_min_duration parameter set to 10 seconds. To increase autovacuum effectiveness, the values for the autovacuum_max_workers and autovacuum_vacuum_cost_limit parameters are computed based on host memory capacity to provide larger default values.

  • Improved transaction timeout – The parameter idle_in_transaction_session_timeout is set to 24 hours. Any session that has been idle more than 24 hours is terminated.

  • Performance metrics – The pg_stat_statements extension is included in shared_preload_libraries by default. This avoids having to reboot the instance immediately after creation. However, this functionality still requires you to run the statement CREATE EXTENSION pg_stat_statements;. Also, track_io_timing is enabled by default to add more granular data to pg_stat_statements.

  • The tsearch2 extension is no longer supported – If your application uses tsearch2 functions, update it to use the equivalent functions provided by the core PostgreSQL engine. For more information about the tsearch2 extension, see PostgreSQL tsearch2.

  • The chkpass extension is no longer supported – For more information about the chkpass extension, see PostgreSQL chkpass.

  • Extension updates for RDS for PostgreSQL 11.1 include the following:

    • pgaudit is updated to 1.3.0

    • pg_hint_plan is updated to 1.3.2

    • pglogical is updated to 2.2.1

    • plcoffee is updated to 2.3.8

    • plv8 is updated to 2.3.8

    • PostGIS is updated to 2.5.1

    • prefix is updated to 1.2.8

    • wal2json is updated to hash 9e962bad

For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.

PostgreSQL 10 versions (Deprecated)

PostgreSQL version 10.23 on Amazon RDS (Deprecated)

PostgreSQL version 10.23 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the PostgreSQL 10.23 release.

New features and enhancements

  • PostgreSQL version 10.23 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.

This version includes the following changes:

  • The seg extension version 1.1 is added.

  • The tcn extension version 1.0 is added.

  • The orafce extension is updated to 3.24.

  • The pgaudit extension is updated to 1.2.4.

  • PostGIS dependency GDAL is updated to 3.4.3.

  • PostGIS dependency PROJ is updated to 7.0.1.

  • The wal2json extension is updated to 2.5.

  • The aws_s3 extension is updated to 1.1.

For version information on all extensions, see Extensions supported for RDS for PostgreSQL 10.

PostgreSQL version 10.22 on Amazon RDS (Deprecated)

PostgreSQL version 10.22 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in PostgreSQL 10.22.

This version includes the following change:

  • The PostGIS extension is updated to 3.1.7

For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.

PostgreSQL version 10.21 on Amazon RDS (Deprecated)

PostgreSQL version 10.21 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in PostgreSQL 10.21.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.

PostgreSQL version 10.20 on Amazon RDS (Deprecated)

PostgreSQL version 10.20 is now available on Amazon RDS. PostgreSQL version 10.20 contains several improvements that were announced for PostgreSQL release 10.20.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.

PostgreSQL version 10.19 on Amazon RDS (Deprecated)

PostgreSQL version 10.19 is now available on Amazon RDS. PostgreSQL version 10.19 contains several improvements that were announced for PostgreSQL release 10.19.

This version also includes the following change:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.

PostgreSQL version 10.18 on Amazon RDS (Deprecated)

PostgreSQL version 10.18 is now available on Amazon RDS. PostgreSQL version 10.18 contains several improvements that were announced for PostgreSQL release 10.18.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.

PostgreSQL version 10.17 on Amazon RDS (Deprecated)

PostgreSQL version 10.17 is now available on Amazon RDS. PostgreSQL version 10.17 contains several improvements that were announced for PostgreSQL release 10.17.

This version also includes the following change:

  • The orafce extension is updated to version 3.15.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.

PostgreSQL version 10.16 on Amazon RDS (Deprecated)

PostgreSQL version 10.16 is now available on Amazon RDS. PostgreSQL version 10.16 contains several improvements that were announced for PostgreSQL release 10.16.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.

PostgreSQL version 10.15 on Amazon RDS (Deprecated)

PostgreSQL version 10.15 is now available on Amazon RDS. PostgreSQL version 10.15 contains several improvements that were announced for PostgreSQL release 10.15.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.

PostgreSQL version 10.14 on Amazon RDS (Deprecated)

PostgreSQL version 10.14 is now available on Amazon RDS. PostgreSQL version 10.14 contains several improvements that were announced for PostgreSQL release 10.14.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.

PostgreSQL version 10.13 on Amazon RDS (Deprecated)

PostgreSQL version 10.13 contains several bug fixes for issues in release 10.12. For more information on the fixes in PostgreSQL 10.13, see the PostgreSQL 10.13 documentation.

This version also includes the following change:

  • Upgraded the pg_hint_plan extension to version 1.3.5.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.

PostgreSQL version 10.12 on Amazon RDS (Deprecated)

PostgreSQL version 10.12 contains several bug fixes for issues in release 10.11. For more information on the fixes in PostgreSQL 10.12, see the PostgreSQL 10.12 documentation.

PostgreSQL version 10.11 on Amazon RDS (Deprecated)

PostgreSQL version 10.11 contains several bug fixes for issues in release 10.10. For more information on the fixes in PostgreSQL 10.11, see the PostgreSQL documentation. Changes in this version include the following:

  • Added the plprofiler extension.

PostgreSQL version 10.10 on Amazon RDS (Deprecated)

PostgreSQL version 10.10 contains several bug fixes for issues in release 10.9. For more information on the fixes in PostgreSQL 10.10, see the PostgreSQL documentation. Changes in this version include the following:

PostgreSQL version 10.9 on Amazon RDS (Deprecated)

This release contains an important security fix and also bug fixes and improvements done by the PostgreSQL community. For more information on the security fix, see the PostgreSQL community announcement and security fix CVE-2019-10164.

With this release, the pg_hint_plan extension has been updated to version 1.3.3.

For more information on the fixes in PostgreSQL 10.9, see the PostgreSQL documentation.

PostgreSQL version 10.7 on Amazon RDS (Deprecated)

PostgreSQL version 10.7 contains several bug fixes for issues in release 10.6. For more information on the fixes in 10.7, see the PostgreSQL documentation.

This version also includes the following changes:

For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

PostgreSQL version 10.6 on Amazon RDS (Deprecated)

PostgreSQL version 10.6 contains several bug fixes for issues in release 10.5. For more information on the fixes in PostgreSQL 10.6, see the PostgreSQL documentation.

This version also includes the following changes:

  • A new rds.restrict_password_commands parameter and a new rds_password role have been introduced. When the rds.restrict_password_commands parameter is enabled, only users who have the rds_password role can make user password and password expiration changes. By restricting password-related operations to a limited set of roles, you can implement policies such as password complexity requirements from the client side. The rds.restrict_password_commands parameter is static, so it requires a database restart to change it. For more information, see Restricting password management in the Amazon RDS User Guide.

  • The logical decoding plugin wal2json has been updated to commit 9e962ba.

For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.

Note

Amazon RDS for PostgreSQL has announced the removal of the tsearch2 extension in the next major release. We encourage customers still using pre-8.3 text search to migrate to the equivalent built-in features. For more information about migrating, see the PostgreSQL documentation.

PostgreSQL version 10.5 on Amazon RDS (Deprecated)

PostgreSQL version 10.5 contains several bug fixes for issues in release 10.4. For more information on the fixes in 10.5, see the PostgreSQL documentation.

This version also includes the following changes:

  • Support for the pglogical extension version 2.2.0. Prerequisites for using this extension are the same as the prerequisites for using logical replication for PostgreSQL as described in Performing logical replication for Amazon RDS for PostgreSQL in the Amazon RDS User Guide.

  • Support for the pg_similarity extension version 1.0.

  • Support for the pageinspect extension version 1.6.

  • Support for the libprotobuf extension version 1.3.0 for the PostGIS component.

  • An update for the pg_hint_plan extension to version 1.3.1.

  • An update for the wal2json extension to version 01c5c1e.

For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.

PostgreSQL version 10.4 on Amazon RDS (Deprecated)

PostgreSQL version 10.4 contains several bug fixes for issues in release 10.3. For more information on the fixes in 10.4, see the PostgreSQL documentation.

This version also includes the following changes:

  • Support for PostgreSQL 10 Logical Replication using the native publication and subscription framework. RDS for PostgreSQL databases can function as both publishers and subscribers. You can specify replication to other PostgreSQL databases at the database-level or at the table-level. With logical replication, the publisher and subscriber databases need not be physically identical (block-to-block) to each other. This allows for use cases such as data consolidation, data distribution, and data replication across different database versions for 10.4 and above. For more information, see Performing logical replication for Amazon RDS for PostgreSQL in the Amazon RDS User Guide.

  • The temporary file size limitation is user-configurable. You require the rds_superuser role to modify the temp_file_limit parameter.

  • Update of the GDAL library, which is used by the PostGIS extension. See Managing spatial data with the PostGIS extension in the Amazon RDS User Guide.

  • Update of the ip4r extension to version 2.1.1.

  • Update of the pg_repack extension to version 1.4.3. See Working with the pg_repack extension in the Amazon RDS User Guide.

  • Update of the plv8 extension to version 2.1.2.

For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.

Note

The tsearch2 extension is to be removed in the next major release. We encourage customers still using pre-8.3 text search to migrate to the equivalent built-in features. For more information about migrating, see the PostgreSQL documentation.

PostgreSQL version 10.3 on Amazon RDS (Deprecated)

PostgreSQL version 10.3 contains several bug fixes for issues in release 10. For more information on the fixes in 10.3, see the PostgreSQL documentation.

Version 2.1.0 of plv8 is now available. If you use plv8 and upgrade PostgreSQL to a new plv8 version, you immediately take advantage of the new extension but the catalog metadata doesn't reflect this fact. For the steps to synchronize your catalog metadata with the new version of plv8, see Upgrading PLV8 in the Amazon RDS User Guide.

For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.

PostgreSQL version 10.1 on Amazon RDS (Deprecated)

PostgreSQL version 10.1 contains several bug fixes for issues in release 10. For more information on the fixes in 10.1, see the PostgreSQL documentation and the PostgreSQL 10 community announcement.

For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

PostgreSQL version 10.1 includes the following changes:

  • Declarative table partitioning – PostgreSQL 10 adds table partitioning to SQL syntax and native tuple routing.

  • Parallel queries – When you create a new PostgreSQL 10.1 instance, parallel queries are enabled for the default.postgres10 parameter group. The parameter max_parallel_workers_per_gather is set to 2 by default, but you can modify it to support your specific workload requirements.

  • Support for the international components for unicode (ICU) – You can use the ICU library to provide explicitly versioned collations. Amazon RDS for PostgreSQL 10.1 is compiled with ICU version 60.2. For more information about ICU implementation in PostgreSQL, see Collation support.

  • Huge pages – Huge pages is a feature of the Linux kernel that uses multiple page size capabilities of modern hardware architectures. Amazon RDS for PostgreSQL supports huge pages with a global configuration parameter. When you create a new PostgreSQL 10.1 instance with RDS, the huge_pages parameter is set to "on" for the default.postgres10 parameter group. You can modify this setting to support your specific workload requirements.

  • Extension plv8 update – plv8 is a procedural language that you can use to write functions in JavaScript that you can then call from SQL. This release of PostgreSQL supports version 2.1.0 of plv8.

  • Renaming of xlog and location – In PostgreSQL version 10 the abbreviation "xlog" has changed to "wal", and the term "location" has changed to "lsn". For more information, see https://www.postgresql.org/docs/10/static/release-10.html#id-1.11.6.8.4.

  • tsearch2 extension – Amazon RDS continues to provide the tsearch2 extension in PostgreSQL version 10, but is to remove it in the next major version release. If your application uses tsearch2 functions update it to use the equivalent functions the core engine provides. For more information see tsearch2 in the PostgreSQL documentation.

For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.

PostgreSQL 9.6 versions (Deprecated)

PostgreSQL version 9.6.24 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.24 is now available on Amazon RDS. PostgreSQL version 9.6.24 contains several improvements that were announced for PostgreSQL release 9.6.24.

This version also includes the following change:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .

PostgreSQL version 9.6.23 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.23 is now available on Amazon RDS. PostgreSQL version 9.6.23 contains several improvements that were announced for PostgreSQL release 9.6.23.

This version also includes the following changes:

For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .

PostgreSQL version 9.6.22 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.22 is now available on Amazon RDS. PostgreSQL version 9.6.22 contains several improvements that were announced for PostgreSQL release 9.6.22.

This version also includes the following change:

  • The orafce extension is updated to version 3.15.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .

PostgreSQL version 9.6.21 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.21 is now available on Amazon RDS. PostgreSQL version 9.6.21 contains several improvements that were announced for PostgreSQL release 9.6.21.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .

PostgreSQL version 9.6.20 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.20 is now available on Amazon RDS. PostgreSQL version 9.6.20 contains several improvements that were announced for PostgreSQL release 9.6.20.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .

PostgreSQL version 9.6.19 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.19 is now available on Amazon RDS. PostgreSQL version 9.6.19 contains several improvements that were announced for PostgreSQL release 9.6.19.

This version also includes the following changes:

  • Upgraded the pgaudit extension to version 1.1.2

  • Upgraded the pglogical extension to version 2.2.2

  • Upgraded the wal2json extension to version 2.3

For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .

PostgreSQL version 9.6.18 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.18 contains several bug fixes for issues in release 9.6.17. For more information on the fixes in PostgreSQL 9.6.18, see the PostgreSQL 9.6.18 documentation.

This version also includes the following change:

  • Upgraded the pg_hint_plan extension to version 1.2.6.

For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .

PostgreSQL version 9.6.17 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.17 contains several bug fixes for issues in release 9.6.16. For more information on the fixes in PostgreSQL 9.6.17, see the PostgreSQL 9.6.17 documentation.

PostgreSQL version 9.6.16 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.16 contains several bug fixes for issues in release 9.6.15. For more information on the fixes in PostgreSQL 9.6.16, see the PostgreSQL documentation.

PostgreSQL version 9.6.15 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.15 contains several bug fixes for issues in release 9.6.14. For more information on the fixes in PostgreSQL 9.6.15, see the PostgreSQL documentation.

The PostGIS extension is updated to version 2.5.2.

PostgreSQL version 9.6.14 on Amazon RDS (Deprecated)

This release contains bug fixes and improvements done by the PostgreSQL community.

With this release, the pg_hint_plan extension has been updated to version 1.2.5.

For more information on the fixes in PostgreSQL 9.6.14, see the PostgreSQL documentation.

PostgreSQL version 9.6.12 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.12 contains several bug fixes for issues in release 9.6.11. For more information on the fixes in 9.6.12, see the PostgreSQL documentation.

For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

PostgreSQL version 9.6.11 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.11 contains several bug fixes for issues in release 9.6.10. For more information on the fixes in PostgreSQL 9.6.11, see the PostgreSQL documentation. For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

With this version, the logical decoding plugin wal2json has been updated to commit 9e962ba.

For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.

PostgreSQL version 9.6.10 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.10 contains several bug fixes for issues in release 9.6.9. For more information on the fixes in 9.6.10, see the PostgreSQL documentation.

This version includes the following changes:

  • Support for the pglogical extension version 2.2.0. Prerequisites for using this extension are the same as the prerequisites for using logical replication for PostgreSQL as described in Performing logical replication for Amazon RDS for PostgreSQL in the Amazon RDS User Guide.

  • Support for the pg_similarity extension version 2.2.0.

  • An update for the wal2json extension to version 01c5c1e.

  • An update for the pg_hint_plan extension to version 1.2.3.

For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.

PostgreSQL version 9.6.9 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.9 contains several bug fixes for issues in release 9.6.8. For more information on the fixes in 9.6.9, see the PostgreSQL documentation. For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

This version includes the following changes:

For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.

PostgreSQL version 9.6.8 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.8 contains several bug fixes for issues in release 9.6.6. For more information on the fixes in 9.6.8, see the PostgreSQL documentation. For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.

PostgreSQL version 9.6.6 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.6 contains several bug fixes for issues in release 9.6.5. For more information on the fixes in 9.6.6, see the PostgreSQL documentation. For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

This version includes the following features:

  • Supports the orafce extension, version 3.6.1. This extension contains functions that are native to commercial databases, and can be helpful if you are porting a commercial database to PostgreSQL. For more information about using orafce with Amazon RDS, see Using functions from the orafce extensionin the Amazon RDS User Guide.

  • Supports the prefix extension, version 1.2.6. This extension provides an operator for text prefix searches. For more information about prefix, see the prefix project on GitHub.

  • Supports version 2.3.4 of PostGIS, version 2.4.2 of pgrouting, and an updated version of wal2json.

For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.

PostgreSQL version 9.6.5 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.5 contains several bug fixes for issues in release 9.6.4. For more information on the fixes in 9.6.5, see the PostgreSQL documentation. For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

This version also includes support for the pgrouting, postgresql-hll extensions, and the decoder_raw optional extension.

For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.

PostgreSQL version 9.6.3 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.3 contains several new features and bug fixes. This version includes the following features:

  • Supports the extension pg_repack version 1.4.0. You can use this extension to remove bloat from tables and indexes. For more information on using pg_repack with Amazon RDS, see Reducing bloat in tables and indexes with the pg_repack extension in the Amazon RDS User Guide.

  • Supports the extension pgaudit version 1.1.0. This extension provides detailed session and object audit logging. For more information on using pgaudit with Amazon RDS, see Logging at the session and object level with the pgaudit extension in the Amazon RDS User Guide.

  • Supports wal2json, an output plugin for logical decoding.

  • Supports the auto_explain extension. You can use this extension to log execution plans of slow statements automatically. The following example shows how to use auto_explain from within an Amazon RDS PostgreSQL session:

    LOAD '$libdir/plugins/auto_explain';

    For more information on using auto_explain, see the PostgreSQL documentation.

PostgreSQL version 9.6.2 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.2 contains several new features and bug fixes. The new version also includes the following extension versions:

  • PostGIS version 2.3.2

  • pg_freespacemap version 1.1–Provides a way to examine the free space map (FSM). This extension provides an overloaded function called pg_freespace. The functions show the value recorded in the free space map for a given page, or for all pages in the relation.

  • pg_hint_plan version 1.1.3– Provides control of execution plans by using hinting phrases at the beginning of SQL statements.

  • log_fdw version 1.0–Using this extension from Amazon RDS, you can load and query your database engine log from within the database. For more information, see Using the log_fdw extension to access the DB log using SQL in the Amazon RDS User Guide.

  • With this version release, you can now edit the max_worker_processes parameter in a DB parameter group.

PostgreSQL version 9.6.2 on Amazon RDS also supports altering enum values. For more information, see Custom data types and enumerations with RDS for PostgreSQL in the Amazon RDS User Guide.

For more information on the fixes in 9.6.2, see the PostgreSQL documentation. For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

PostgreSQL version 9.6.1 on Amazon RDS (Deprecated)

PostgreSQL version 9.6.1 contains several new features and improvements. For more information about the fixes and improvements in PostgreSQL 9.6.1, see the PostgreSQL documentation. For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide. For information about performing parallel queries and phrase searching using Amazon RDS for PostgreSQL 9.6.1, see the AWS Database Blog.

PostgreSQL version 9.6.1 includes the following changes:

  • Parallel query processing: Supports parallel processing of large read-only queries, allowing sequential scans, hash joins, nested loops, and aggregates to be run in parallel. By default, parallel query processing isn't enabled. To enable parallel query processing, set the parameter max_parallel_workers_per_gather to a value larger than zero.

  • Updated postgres_fdw extension: Supports remote JOINs, SORTs, UPDATEs, and DELETE operations.

  • plv8 update: Provides version 1.5.3 of the plv8 language.

  • PostGIS version update: Supports POSTGIS="2.3.0 r15146" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.1.1, released 2016/07/07" LIBXML="2.9.1" LIBJSON="0.12" RASTER

  • Vacuum improvement: Avoids scanning pages unnecessarily during vacuum freeze operations.

  • Full-text search support for phrases: Supports the ability to specify a phrase-search query in tsquery input using the new operators <-> and <N>.

  • Two new extensions are supported:

    • bloom, an index access method based on Bloom filters

    • pg_visibility, which provides a means for examining the visibility map and page-level visibility information of a table.

  • With the release of version 9.6.2, you can now edit the max_worker_processes parameter in a PostgreSQL version 9.6.1 DB parameter group.

Deprecation of PostgreSQL 10

On April 17, 2023, Amazon RDS plans to deprecate PostgreSQL 10. For more information, see Deprecation of PostgreSQL version 10 in the Amazon RDS User Guide. We strongly recommend that you take action as soon as possible and upgrade your PostgreSQL databases running on major version 10 to a later major version, such as version 14. For information about how to do so, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.

Deprecation of PostgreSQL 9.6

On March 31, 2022, Amazon RDS deprecated PostgreSQL 9.6. This extended the previously announced date of January 18, 2022 to April 26, 2022. For more information, see Deprecation of PostgreSQL version 9.6 in the Amazon RDS User Guide. We strongly recommend that you upgrade all your PostgreSQL 9.6 DB instances to PostgreSQL 12 or higher as soon as possible. For information about how to do so, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.