System Requirements for Amazon Aurora PostgreSQL

To back up and restore PostgreSQL data on an Amazon application, verify that your environment meets the requirements.

Before Configuring Backups, Verify Backup Gateway Region and Access to the Database

Before configuring backups of the database, do the following:

• Verify that the AWS backup gateway is deployed in the same region and VPC as the AWS database.

• Verify that the AWS backup gateway can access the AWS databases. For more information, go to Automatically connecting an EC2 instance and an RDS database on the Amazon RDS website.

• See the following:

  • System Requirements for AWS Backup Gateways

  • For instructions to create an AWS backup gateway, which is part of configuring backups, see the "Configuring Backups" page for the database, under AWS Cloud Databases. For example, Configuring Backups for Amazon DocumentDB Instances.

Software Requirements

• Package required on access nodes

  • Virtual Server Agent

  • MySQL Agent

• Access nodes that you run backup and restore operations on must have one of the following operating systems:

Supported PostgreSQL Versions

PostgreSQL 16.x-11.x

User Account Requirements

• The PostgreSQL instance must have a user account with the following privileges to perform backup and restore operations of the database objects:

  Operation	Required privileges
  Backups	CREATEDB CREATEROLE
  Restores	CREATEDB CREATEROLE INHERIT LOGIN

• CONNECTION LIMIT, if set, must be 2 or greater.

• You might need to grant other privileges to the backup user to secure the objects in the database. For more information, see Privileges on the PostgreSQL website.

SSL and TLS Support

The supported TLS versions to create Amazon SSL encrypted PostgreSQL instances are TLS 1.0, 1.1, and 1.2.