To back up and restore Amazon RDS for PostgreSQL, verify that your environment meets the system requirements.
Software Requirements
Packages required on access nodes:
Virtual Server Agent
PostgreSQL Agent
Access nodes that you run backup and restore operations on must have one of the following operating systems:
Red Hat Enterprise Linux 8.x
Red Hat Enterprise Linux 7.x
Oracle Linux Enterprise
CentOS 8.x
CentOS 7.x
Windows 2012
Windows 2016
Windows 2019
Note: If you have network configuration enabled on the access nodes, before you deploy a Windows or a Linux proxy, configure a firewall on the cloud proxy and on-premises. For more information, see Configuring a Firewall to Install the Virtual Server Agent on a Cloud VM or Instance.
User Account Requirements
For DumpBasedBackupSet, verify that the PostgreSQL agent has a user account with sufficient privileges to perform the following:
Perform backup and restore operations
Access the PostgreSQL database objects as part of the subclient content
The following table illustrates the necessary privileges the user account should have to perform backup and restore operations:
Operations
Privileges PostgreSQL User Should Have
Backup
CREATEDB, CREATEROLE
Restore
CREATEDB, CREATEROLE, INHERIT, LOGIN
CONNECTION LIMIT, if set, should at least have a value of 2.
Initially, the user account credentials is provided during the instance configuration after the installation of the agent. You can change the user account at the instance level.
Supported PostgreSQL Versions
From PostgreSQL version 9.6 to version 13.x
SSL and TLS Support
The supported TLS versions to create Amazon SSL encrypted PostgreSQL instances are TLS 1.0, 1.1 and 1.2.