Issue:
In the event of a vertica crash, how can I restore my vertica database to a good backup
Answer:
Assuming backups have been previously configured per the documentation, please follow these steps to restore the database …
cd /opt/vertica/bin/
As the dradmin (or equivalent user) run: ./vbr.py --task restore --config-file <filename>.ini
Note: <filename>.ini represents the backup configuration file created when you configured your backups. To locate this file, if you don’t know where it, is do the following …
crontab -l to show the crontab entry from the configured backup script
Example: crontab -l
00 02 * * * /export/dradmin/backups/backup_script.sh >/tmp/backup.log 2>&1
2. cat /export/dradmin/backups/backup_script.sh
Example: cat /export/dradmin/backups/backup_script.sh
/opt/vertica/bin/vbr.py --task backup --config-file /export/dradmin/backups/backup.ini
As you can see the backup.ini file is in /export/dradmin/backups/ so the command that would need to be run to restore the vertica database would be:
./vbr.py --task restore --config-file /export/dradmin/backups/backup.ini