vbr.py to copy tables between two vertica servers

What's you'r Vertica version ?

You can repicate tables/schemas between databases since 7.2.3. Below link explains how to do it.

https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/ReplicatingtoanAlternateCluster.htm

i have vertica 7.1 .I am trying to copy selected objects  from one dev server to another test server .

i created object specific backup in specified directory /tmp/vbr . Then i copied the files in /tmp/vbr data to test server and tried to run restore but getting the error shown below

vbr.py -t restore --config-file  tk1.ini

Enter vertica password for user dbadmin:

Preparing...

The authenticity of host '192.168.52.128 (192.168.52.128)' can't be established.

RSA key fingerprint is 85:3a:4c:99:c9:27:45:f4:08:69:c4:3d:36:fc:96:51.

Are you sure you want to continue connecting (yes/no)? yes

Found Database port:  5433

reverse mapping checking getaddrinfo for hgw failed - POSSIBLE BREAK-IN ATTEMPT!

reverse mapping checking getaddrinfo for hgw failed - POSSIBLE BREAK-IN ATTEMPT!

reverse mapping checking getaddrinfo for hgw failed - POSSIBLE BREAK-IN ATTEMPT!

reverse mapping checking getaddrinfo for hgw failed - POSSIBLE BREAK-IN ATTEMPT!

reverse mapping checking getaddrinfo for hgw failed - POSSIBLE BREAK-IN ATTEMPT!

reverse mapping checking getaddrinfo for hgw failed - POSSIBLE BREAK-IN ATTEMPT!

reverse mapping checking getaddrinfo for hgw failed - POSSIBLE BREAK-IN ATTEMPT!

reverse mapping checking getaddrinfo for hgw failed - POSSIBLE BREAK-IN ATTEMPT!

reverse mapping checking getaddrinfo for hgw failed - POSSIBLE BREAK-IN ATTEMPT!

Copying...

[==================================================] 100%

All child processes terminated successfully.

SQL command select load_snapshot_prep('tk1', true); failed:

ERROR 4757:  SnapshotMemento does not match. Oid conflicts are possible

HINT:  Try restoring a cluster wide backup together

restore failed!

Retrying... #1

Copying...

[==================================================] 100%

All child processes terminated successfully.

SQL command select load_snapshot_prep('tk1', true); failed:

ERROR 4757:  SnapshotMemento does not match. Oid conflicts are possible

HINT:  Try restoring a cluster wide backup together

restore failed!

Retrying... #2

Copying...

[==================================================] 100%

All child processes terminated successfully.

SQL command select load_snapshot_prep('tk1', true); failed:

ERROR 4757:  SnapshotMemento does not match. Oid conflicts are possible

HINT:  Try restoring a cluster wide backup together

restore failed!

Unfortunately Vertica doesn't support restoring and replicating objects to another database before 7.2 and 7.2.3 respectively.

Still you can't prior to 7.2. Old machinery depends on the meta-data of the database (where backup was taken) itself, make it impossible to restore to another database.

---

tharanga wrote:

Still you can't prior to 7.2. Old machinery depends on the meta-data of the database (where backup was taken) itself, make it impossible to restore to another database.

---

Maybe I am misunderstanding but could you clarify your comment?  Are you saying that you can only do an object level backup/restore in Vertica 7.2 or greater?  It looks like the documentation says object level backup/restore is available in 6.x or greater.  Maybe I am misunderstanding that to which you are referring.  Thank you!

https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/BackingUpAndRestoringTheDatabase.htm 

"Compatibility Requirements for Restore and Replication

Creating backups with vbr requires restoring backups with the same utility. Vertica 6.x and later supports object-level backups.

Vertica supports restore, replication, and copycluster actions only to the same exact version of Vertica that created the backup. For example, you cannot restore, replicate objects, or copycluster a version 7.0.2-3 backup to a version 7.0.2-5 database."

Priot to 7.2, if you take an object backup, you can ONLY restore that to the same database.

On or after 7.2, an object backup taken from a database can be restored to the SAME or ANOTHER database, provided other database is the same version and have same number of nodes. Rest (node names, IP addresses, storage locations, etc) can be different.

Great - thank you for the clarification.  Be nice if the documentation explained it as well as you have.