What's New

1

New RDS for PostgreSQL documentation is available.

Upgraded documentation structure, clear scenario demonstrations, and beautified presentations ensure a smooth and enjoyable reading experience for you.

Commercial use

Working with RDS for PostgreSQL

1

RDS for PostgreSQL supports DBA Assistant.

DBA Assistant allows you to monitor, diagnose, and tune databases.

Commercial use

Problem Diagnosis and SQL Analysis

1

RDS for PostgreSQL supports replication delays for read replicas.

You can configure a replication delay for a read replica. The read replica replays the WAL logs received from the primary instance after the specified delay.

Open beta testing

Configuring Replication Delay for a Read Replica

2

Some v3 APIs are added for RDS for PostgreSQL.

The following v3 APIs are added:

• API for changing the billing mode from pay-per-use to yearly/monthly

• API for querying the recovery time window of WAL logs

Commercial use

Changing the Billing Mode from Pay-per-Use to Yearly/Monthly

Querying the Recovery Time Window of WAL Logs

1

RDS for PostgreSQL supports the dblink and rds_pg_sql_ccl extensions.

RDS for PostgreSQL supports the dblink and rds_pg_sql_ccl extensions.

Commercial use

dblink

rds_pg_sql_ccl

1

Performance test data is updated for RDS for PostgreSQL.

Performance test data is updated for RDS for PostgreSQL 12, 13, 14, and 15.

Commercial use

RDS for PostgreSQL Performance White Paper

1

Some v3 APIs are added for RDS for PostgreSQL.

The following v3 APIs are added:

• API for stopping a backup (RDS for PostgreSQL)

• API for changing the database owner

• API for granting a role to a user

• API for revoking a role from a user

• API for querying roles

• API for updating an extension

• API for adding a SQL statement concurrency control rule for a database

• API for deleting a SQL statement concurrency control rule

• API for modifying a SQL statement concurrency control rule

• API for querying SQL statement concurrency control rules

• API for opening or closing a SQL statement concurrency control rule or disabling all SQL statement concurrency control rules

Commercial use

Stopping a Backup (RDS for PostgreSQL)

Changing the Database Owner

Updating a Plugin

Adding a SQL Statement Concurrency Control Rule for a Database

1

RDS for PostgreSQL 15 is supported.

RDS for PostgreSQL 15 is available to you.

Commercial use

DB Engines and Versions

1

Some v3 APIs are added.

The following v3 APIs are added:

• API for querying the target version to which a DB instance can be upgraded (RDS for PostgreSQL)

• API for performing a major version upgrade pre-check for a DB instance (RDS for PostgreSQL)

• API for querying the major version check status or upgrade status of a DB instance (RDS for PostgreSQL)

• API for querying the major version upgrade check history of a DB instance (RDS for PostgreSQL)

• API for upgrading a major version of a DB instance (RDS for PostgreSQL)

• API for querying the major version upgrade history of a DB instance (RDS for PostgreSQL)

Commercial use

Querying the Target Version to Which a DB Instance Can Be Upgraded (RDS for PostgreSQL)

1

RDS for PostgreSQL supports modifications to the pg_hba.conf file.

You can modify parameters in the pg_hba.conf file for your DB instance to ensure access to your database.

Commercial use

Modifying pg_hba.conf

2

Some v3 APIs are added.

The following v3 APIs are added:

• API for querying the pg_hba.conf file configurations of a DB instance

• API for modifying or adding one or more records in the pg_hba.conf file

• API for overwriting the pg_hba.conf file

• API for deleting one or more records from the pg_hba.conf file

• API for querying the pg_hba.conf change history of a DB instance

Commercial use

Querying the pg_hba.conf File Configurations of a DB Instance

Modifying or Adding One or More Records in the pg_hba.conf File

Overwriting the pg_hba.conf File

Deleting One or More Records from the pg_hba.conf File

1

RDS for PostgreSQL 15 is supported.

RDS for PostgreSQL 15 is available to you.

Open beta testing

DB Engines and Versions

1

RDS for PostgreSQL supports storage type changes.

You can change the storage type of your RDS for PostgreSQL DB instance as needed.

Open beta testing

Changing the Storage Type

1

RDS for PostgreSQL supports the pgvector and pgl_ddl_deploy plugins.

The pgvector and pgl_ddl_deploy plugins are available to you.

Commercial use

Using pgvector

Using pgl_ddl_deploy

2

RDS for PostgreSQL supports storage autoscaling.

You can enable storage autoscaling for your DB instance. When the storage space usage reaches the upper limit, autoscaling is triggered.

Open beta testing

Storage Autoscaling

3

RDS for PostgreSQL supports parameter template import.

RDS for PostgreSQL allows you to import a parameter template from a local directory for future use.

Open beta testing

Importing a Parameter Template

4

RDS for PostgreSQL supports SQL audit.

After you enable SQL audit for your DB instance, all SQL operations will be logged, and you can download audit logs to view details.

Commercial use

Enabling SQL Audit

1

RDS for PostgreSQL supports log reporting to Log Tank Service (LTS).

Error logs and slow query logs generated by DB instances can be uploaded to LTS for management.

Open beta testing

Log Reporting

1

RDS for PostgreSQL 14 is supported.

You can create RDS for PostgreSQL 14 instances.

Commercial use

DB Engines and Versions

1

An example about how to buy and connect to an RDS for PostgreSQL instance is added.

This example illustrates how to purchase an RDS for PostgreSQL instance and how to connect to it using DAS.

Commercial use

Buying an RDS for PostgreSQL Instance and Connecting to It Through DAS

1

RDS for PostgreSQL instances can be stopped and started using APIs.

• You can stop an instance through v3 APIs.

• You can start an instance through v3 APIs.

Commercial use

Stopping an Instance

Starting an Instance

2

RDS for PostgreSQL supports minor version upgrades.

You can manually upgrade minor versions of RDS for PostgreSQL instances to improve performance, add new functions, and fix bugs.

Commercial use

Upgrading a Minor Version

1

RDS for PostgreSQL supports the pg_repack plugin.

The pg_repack plugin is available for RDS for PostgreSQL.

Commercial use

Using pg_repack

2

New metrics are added for RDS for PostgreSQL.

Slow SQL and DR instance metrics are added for RDS for PostgreSQL.

Commercial use

Configuring Displayed Metrics

3

Suggestions on using RDS for PostgreSQL are added.

Design, development, management, and maintenance specifications are added in Working with RDS for PostgreSQL.

Commercial use

Suggestions on Using RDS for PostgreSQL Instances

1

RDS for PostgreSQL instances can be stopped and started manually.

You can stop your instance temporarily to save money. After stopping your instance, you can restart it to begin using it again.

Open beta testing

Stopping an Instance

Starting an Instance

1

RDS for PostgreSQL supports extreme SSDs.

You can select extreme SSD when buying an RDS for PostgreSQL instance.

Open beta testing

DB Instance Storage Types

2

RDS for PostgreSQL supports failover slots for logical subscriptions.

RDS for PostgreSQL synchronizes information about logical replication slots specified as failover slots from the primary DB instance to the standby DB instance to ensure logical subscriptions remain connected after a primary/standby switchover.

Commercial use

Failover Slot for Logical Subscriptions

1

General-purpose and dedicated instance classes are added for PostgreSQL.

You can choose general-purpose and dedicated instance classes for PostgreSQL.

Commercial use

PostgreSQL Instance Classes

2

RDS for PostgreSQL supports cross-region backup policy settings through v3 APIs.

You can configure cross-region backup policies, query cross-region instances, and configure restoration time ranges of cross-region backups.

Commercial use

Setting a Cross-Region Backup Policy

Querying Details About Cross-Region Backups

Querying Information About a Cross-Region Backup Policy

Querying the Restoration Time Range of a Cross-Region Backup

1

PostgreSQL 13 is supported.

You can choose PostgreSQL 13 as your DB engine.

Open beta testing

DB Engines and Versions

2

RDS for PostgreSQL supports DB instance migration from one AZ to another.

You can migrate an RDS for PostgreSQL DB instance from one AZ to another using the management console or v3 APIs.

Commercial use

Migrating a Standby DB Instance

Migrating a Standby DB Instance

1

RDS for PostgreSQL supports configurations and modifications to private domain names.

You can apply for a private domain name and connect to RDS DB instances through the private domain name.

Open beta testing

Applying for and Modifying a Private Domain Name

1

Database proxy metrics are added to RDS for PostgreSQL.

You can view database proxy metrics monitored for PostgreSQL DB instances.

Commercial use

Configuring Displayed Metrics

2

Database management APIs are added to RDS for PostgreSQL.

You can query details about databases, database users, and database schemas.

Commercial use

Querying Details About Databases

Querying Details About Database Users

Querying Details About Database Schemas

1

RDS for PostgreSQL supports database and user creation using v3 APIs.

You can create databases and database accounts, and authorize database accounts using v3 APIs.

Commercial use

Database and Account Management (PostgreSQL)