Backing Up the Database
Important: OpenText strongly recommends backing up the database on a regular basis. This task is especially important for a single-node environment where K-safety = 0.
OpenText provides a comprehensive utility, the vbr
Python script, that lets you back up, restore, list backups, and copy your database. You can create full and incremental database backups of specific schemas or tables to use with a multi-tenant database. Using vbr
, you can save your data to a variety of locations:
- A local directory on the nodes in the cluster
- One or more hosts outside of the cluster
- A different Vertica cluster (in effect, cloning your database)
Create regular backups of your data by running vbr
from a cron
job or other task scheduler.