myVertica  

Backing Up and Restoring the Database

In this tutorial, we’ll describe the backup and restore process for Vertica.

Overview

Vertica provides multiple backup and restore options, including both manual and automatic processes. All of these options use the vbr utility, which is included with Vertica.

Backup and Restore Options

Depending on the size of your data and your specific business needs, you can perform different backup and restore procedures.
  • Full backup
    A full backup is a complete copy of the database catalog, its schemas, tables, and other objects. This type of backup provides a complete image of the database at the time the backup occurred.
  • Incremental backup
    An incremental backup saves changes made since the last backup was performed.
  • Object-level backup
    An object-level backup consists of one or more objects, such as schemas or tables.
  • Full restore
    A full restore restores all data from a complete backup. Note that a full restore overwrites the contents of the current database; it does not merge the data together.
  • Object-level restore
    You can restore specific objects from respective object-level backups. As of Vertica 7.2, you can restore individual objects from a full backup.

Before You Begin

Since Vertica supplies many backup and restore options, the prerequisites vary. Read these articles in our Knowledge Base for specific prerequisites:
To use the vbr.py utility, you first need to create a configuration file that includes information the utility needs to perform the backup. Create this configuration file by using the following command: /opt/vertica/bin/vbr --setupconfig

Learn More

To learn more about backup and restore in Vertica, see our documentation.