For FSBasedBackupSet, the PostgreSQL agent requires a user account that has sufficient privileges to perform the following:
-
Perform backup and restore operations
-
Access the PostgreSQL Server application
-
Stop or Start PostgreSQL services
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 |
Full Database Administrator privileges. |
|
Restore |
Full Database Administrator privileges. |