For Dump Based backups, you can include list-file in backup by enabling the Collect Object List During Backup option. The list-file contains the table of contents of dumped data. The file is useful to perform table level restore at regular interval.
When the Collect Object List During Backup option is enabled, a list-file is created for each database during backup. During restore operation, the list-file is passed to pg_restore to restore user selected objects like schema, table, functions etc. This speeds up restore operation, however, the backup operation, might consume additional time to create the file.
When the Collect Object List During Backup option is disabled, the list-file is not created during backup. If it is a granular restore, the list-file is created during the restore operation.
The list-file is not required for database level restores.
Procedure
-
From the CommCell Browser, navigate to <Client> | PostgreSQL | DumpBasedBackupSet.
-
Right-click the <Subclient>, and then click Properties.
-
Select the Collect Object List During Backup check box.
-
Click OK.
