Incremental Backup State Files for HEAP Tables

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

When performing an incremental backup using gpcrondump utility, can we only just backup just the changes for HEAP tables instead of the entire table?

Environment

Cause

Per the current design of gpcrondump, when an incremental backup is running, state files are not generated for HEAP tables since they get backed up with every incremental backup. Currently, the gpcrondump utility only compares the state of each table in the database against the last backup using state files. If there is any change in the state of the table since the last backup, it is marked dirty and is backed up during an incremental backup. This procedure currently is followed only for AO/CO tables.

Resolution

A new feature request was submitted to Pivotal Greenplum Engineering team to ask for state files for HEAP tables.