You can use the Commvault software to back up and restore a PostgreSQL server instance that is hosted in the Amazon RDS cloud.
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 are provided during the instance configuration after the installation of the agent. You can change the user account at the instance level.