Restore a Database from a Full Backup

After you create a target cluster, you must restore the database that was on the source cluster:

  1. Using your source cluster backup snapshots, create and attach one volume for each node in your cluster and attach them to the nodes in your target cluster. Verify that the snapshots from the source cluster match with their respective nodes on the target cluster.
    Important: You must use the correct device mapping. For example, a backup snapshot taken for node 1, must be recreated in the new cluster at node 1.
  2. Mount the backup location on all nodes of the target cluster with the same file path as your source cluster:
    sudo bash -c "echo '/dev/xvdf /vertica/backup ext4 defaults 0 0' > /etc/fstab"
    sudo mkdir /vertica/backup
    sudo mount /vertica/backup
  3. Verify the success of your mounting operation by checking for data in your backup folder:
    ls /vertica/backup/
  4. Using your admintools.conf file backup as a reference, create an empty database on the target cluster with the same dbadmin username, password, data path, and database name as your source database.
  5. Stop the database, if it is running.
  6. Run a restore operation:
    /opt/vertica/bin/vbr --config-file vmart_backup.ini --task restore
  7. Start the database to conclude the restoration process.