Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Question regarding vertica hard link backup

raulk89raulk89
edited October 2021 in General Discussion

Hi

Vertica 11.0.1

What happens when I create hardlink local backup and data is changed in a database. Due to that, basically some database files are changed/modified.

But doesn't this change the file for hardlink backup also..?

For example.

  1. I create hardlink local backup named "hb1"
  2. Update 100 rows in a table and commit
  3. Due to P2, the specific file (let's say inode=100) has been modified.
  4. Hardlink local backup "hb1" now basically contains data for inode=100 from P3

How can I restore my database back to P1 ( I mean how does it work) ?

Regards
Raul

Comments

  • I tried it.

    1. Created hardlink local backup b1
    2. Created table1, inserted 1 row and commit
    3. Created hardlink local backup b2
    4. I stopped database and restored archive b1
    5. This table with data is present

    My question is, what is the point of this hardlink backup..?

    Raul

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.