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.