For DumpBasedBackupSet, the PostgreSQL agent requires a user account that has sufficient privileges to perform backup and restore operations. The user should be the owner of the database backed up using the DumpBased backup set subclient. The user should also be the owner of extension plpgsql, if present.
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, INHERIT, LOGIN |
|
Restore |
CREATEDB, CREATEROLE, INHERIT, LOGIN |
Note
A user account must have superuser privileges to perform a backup of global objects in the PostgreSQL database.
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.