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.
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 |
CREATEDB, CREATEROLE, 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
-
If the database part of a database group (other than default) is renamed or removed, the backup content for database group needs to be updated manually. The old database will not be removed automatically.
-
Backup operations using DumpBased backup set does not include roles and tablespace location information. This is because pg_dump utility that is used to perform DumpBased backup operation does not back up roles and tablespace location information. You can save this information using pg_dumpall utility from the source.