You can perform a logical data dump backup of the data. When you perform a backup operation, the Commvault software invokes the PostgreSQL pg_dump client utility to perform the backup operation. You can perform only a full backup operation.
Note
By default, backup operations using DumpBased backup set do not include information about roles. This is because pg_dump utility that is used to perform DumpBased backup operation does not back up roles information. To save this information using the pg_dumpall utility, enable backups for global objects in PostgreSQL databases.
The user account provided in the Instance Properties dialog box should have sufficient privileges to execute pg_dump and pg_restore on the databases in 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 |
INHERIT, LOGIN |
|
Restore |
CREATEDB, CREATEROLE, INHERIT, LOGIN |
CONNECTION LIMIT, if set, should at least have a value of 2.
Procedure
-
From the CommCell Browser, go to Client Computers > client > PostgreSQL > instance.
-
Right-click the subclient that you created, and then click Backup.
The Backup Options dialog box appears.
-
On the Backup Options tab, select the backup type and the job initiation:
-
In the Select Backup Type area, select Full.
-
In the Job Initiation section, specify when to run the backup operation:
-
To run the job immediately, select Immediate.
-
To schedule the job, select Schedule, and then configure the schedule.
For information about configuring a backup schedule, see Schedule Backups.
-
-
-
Click OK.
Note
The ha_health_check table is excluded from the backups while backing up the PostgreSQL database. This is done to avoid backup failures as the users might not have the required permissions to dump the table.