You can perform a logical data pump backup of the Azure data. When you perform a backup operation, the Commvault software invokes the PostgreSQL pg_dump utility to perform the 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 user should also be a member of azure_pg_admin role.
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.
Before You Begin
If you want to back up a subset of the databases, then create a subclient for the databases. For more information, see Creating PostgreSQL Subclient for an Azure Database.
Procedure
-
From the CommCell Browser, expand Client Computers > client > PostgreSQL > instance > DumpBasedBackupSet.
-
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 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.
