Loading...

Configuring User Accounts for PostgreSQL Backups

FSBased Backup Set

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.

DumpBased Backup Set

For DumpBasedBackupSet, the PostgreSQL agent requires a user account that has 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, INHERIT, LOGIN

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.

At the Instance Level

This user account will be used for all instances and associated subclients. Use the following steps to change the user account for an Instance:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | PostGreSQL.
  2. Right-click the <Instance> and click Properties.
  3. Click the Accounts tab.
  4. Type the user name in the PostGres User Name box.
  5. Type the password in the PostGres Account Password box.
  6. Retype the password in the PostGres Confirm Password box.
  7. Click OK.

Last modified: 8/19/2019 7:05:07 AM