You can perform a full backup operation or an incremental backup operation of a PostgreSQL database.
Before You Begin
For FSBasedBackupSet, verify that the archive directory is properly configured, and that archiving is working.
Procedure
-
From the navigation pane, go to Solutions > Databases > DB Instances.
The Instances page appears.
-
Select the row of the instance that you want to backup, and then click Backup.
The Backup dialog box appears.
-
Select the subclient that you want to back up, and then click Select.
The Select backup level dialog box appears.
-
Under Backup level, select the type of backup that you want to perform, either Full or Incremental.
-
Click OK.
-
Optional: To view the job details, click the job ID.
Note
-
To associate a schedule to a subclient of a DumpBased backup set, first set the plan to none and save the changes. Then, associate the subclient to a storage policy and a schedule policy. Associating a subclient to a backup plan will only associate a storage policy, and not a schedule policy.
-
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.