Skip to main content
Question

When using 'copyclustet' vbr script, does it lock down the Vertica tables?

  • June 7, 2020
  • 1 reply
  • 3 views

Eitaniz

I have 3 different stand-alone Vertica servers (not in a cluster configuration).
I've configured it to copy the whole DB from serve 1 to both servers 2 & 3 and I'm wondering if the DB is being locked during the 'copy cluster' script is running.

1 reply

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • June 8, 2020

There is a brief global lock while Vertica prepares a snapshot of the database. Then the snapshot is used to copycluster.