Skip to main content

Question regarding vertica hard link backup

  • October 27, 2021
  • 1 reply
  • 3 views

raulk89
Forum|alt.badge.img+2

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

1 reply

raulk89
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • October 28, 2021

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