We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


vbr.py copycluster failed — Vertica Forum

vbr.py copycluster failed

I have a 3 vertica nodes production database (version 6.1.2).

Now I want to build same 3 nodes for devel database. I installed same Vertica 6.1.2 on 3 nodes.

I follow the instruction on https://my.vertica.com/docs/6.0.x/HTML/index.htm#16027.htm to copy a database to another cluster.

My config.ini is as below:

[Misc]
snapshotName = test_copycluster
verticaConfig = True
restorePointLimit = 1
objects = public

[Database]
dbName = verticadb
dbUser = dbadmin
dbPromptForPassword = True

[Transmission]

[Mapping0]
dbNode = v_verticadb_node0001
backupHost = vertica-devel1.xxx.com

[Mapping1]
dbNode = v_verticadb_node0002
backupHost = vertica-devel2.xxx.com

[Mapping2]
dbNode = v_verticadb_node0003
backupHost = vertica-devel3.xxx.com

I already have an empty verticadb on devel.

I have a passwordless connection from devel to production (Do we need the vive versa?)

And when I run the command:

vbr.py --config-file config.ini --task copycluster

The process is failed as below:


Enter vertica password for user dbadmin:
Preparing...
Found Database port:  5433
Cannot specify "objects" config parameter for copy cluster.
copycluster failed!

Please help me by telling me what steps I am missing or wrong.

Thanks so much


Minh

Comments

  • A full bkp is required and not a object level. As you try to use in your case. Remeber that all data in the target cluster will be erased !
  • A full bkp is required and not a object level. As you try to use in your case. Remember that all data in the target cluster will be erased !

Leave a Comment

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