# Amazon RDS for PostgreSQL

You can use the Commvault software to back up and restore Amazon RDS for PostgreSQL.

To perform PostgreSQL cloud backups from replica, consider the following recommendation:

1. For PostgreSQL master-replica configurations:

   1. Use the master node for backups to avoid potential conflicts with the recovery process on replicas, which might interfere with tools such as pg_dump. Configuring backups on the master node introduces some overhead, as the Commvault access node connects directly to the master database to perform pg_dump.

   2. If using a replica for backups, ensure to configure max_standby_archive_delay and max_standby_streaming_delay settings to allow sufficient time for the Commvault triggered pg_dump to complete without being canceled due to WAL replay conflicts. For more information, see PostgreSQL Hot Standby Conflicts.

2. Schedule backups during off-peak or quiet hours

   - Schedule backups during off-peak or quiet hours to ensure faster execution and minimize the risk of connection interruptions or resource contention.

## Backups

### Backup Granularity

Database level

### Backups You Can Perform

- Full backups

### When You Can Perform Backups

- On a schedule: the backup plan that you assign manages scheduled backups

- On demand: You can perform on-demand backups at any time

### Data You Can Back Up

- PostgreSQL user databases

  Note

  The following databases will be skipped from the backups of:

  - Amazon RDS PostgresSQL database - rdsadmin, template0, template1

## Restores

### Restore Granularity

- Database level

- Table level

### Backups You Can Use for Restores

- The most recent backup: For example, restore the most recent backup to its original location

- A backup from a specific date: For example, restore data to a point in time before it became unusable

- Backups from a date range: For example, restore data that was accidentally deleted

### Destinations You Can Restore To

- In-place: Restore data to the location that it was backed up from

- Out-of-place: Restore data to the following destinations:

  - Cross-cloud: You can restore PostgreSQL databases from one cloud platform (such as Amazon Web Services and Google Cloud) to a different cloud platform. The source computer and destination computer should have the same operating system.

  - An instance in the same platform or a different platform (such as Alibaba Cloud, Amazon Web Services, Azure, and Google Cloud) across regions

  - An on-premises instance

  - A disk location

Note

- You cannot restore data to Amazon RDS Multi-AZ (Availability Zone) reader instances.

- Commvault supports pgvector extension for Amazon RDS for PostgreSQL. The destination instance should also have pgvector extension in case of Out-of-Place restore.

### PostgreSQL Portability

You can perform the following cross-server restore operations.

Source | Destination
--- | ---
Windows | Linux
Windows | Yes | No
Linux | No | Yes

×

Loading...