Loading...

Performing a Backup of a PostgreSQL Database

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

  1. From the CommCell Browser, go to Client Computers > client > PostgreSQL > instance.
  2. Right-click the subclient that you created, and then click Backup.

    The Backup Options dialog box appears.

  3. On the Backup Options tab, select the backup type and the job initiation:
    1. In the Select Backup Type area, select Full.
    2. 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.

  4. Click OK.

Note: 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.

Last modified: 9/29/2020 8:58:32 AM