The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

How to Check if Restore is Taking Place.

Hi Experts,
1) How can I know that a restore is taking place.
2) How can I see its progress or estimate how much longer it will take.
Thanks!

Tagged:

Answers

  • SruthiASruthiA Employee

    You can check the progress of vbr restore on the vertica node where you started the process. the progress percentage will be printed on the screen
    Example output of vbr restore:
    vbr --task restore --config-file db.ini
    Copying...
    1871652633 out of 1871652633, 100%
    All child processes terminated successfully.
    restore done!

    Other way to know is reviewing vbr.log, it should be present at the path which has been set to tmpDir in your ini file.
    https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/RestoringFullDatabaseBackups.htm

  • Thanks for the quick reply. I forgot to mention that I will want to know if restore is running and its progress when I'm not the one who initiated the vbr restore command and do not have the command line progress.

  • SruthiASruthiA Employee

    In that case, You can check vbr.log by logging into vertica node and check if any rsync process is running in vertica node. vbr uses uses rsync internally for backup/restore.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.