Backing Up a Set of Tables
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 5.x documentation.
Backing Up a Set of Tables
You can create a backup that includes a subset of the schema or tables in a database by using
the following gpcrondump options:
- -t schema.tablename – specify a table to include in the backup. You can use the -t option multiple times.
- --table-file=filename – specify a file containing a list of tables to include in the backup.
- -T schema.tablename – specify a table to exclude from the backup. You can use the -T option multiple times.
- --exclude-table-file=filename – specify a file containing a list of tables to exclude from the backup.
- -s schema_name – include all tables qualified by a specified schema name in the backup. You can use the -s option multiple times.
- --schema-file=filename – specify a file containing a list of schemas to include in the backup.
- -S schema_name – exclude tables qualified by a specified schema name from the backup. You can use the -S option multiple times.
- --exclude-schema-file=filename – specify a file containing schema names to exclude from the backup.
Refer to Incremental Backup with Sets for additional information about using these gpcrondump options with incremental backups.