vbr.py copycluster failed

Minh_Phan

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

Adrian_Oprea

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 !

Adrian_Oprea_1

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 !