How do I backup and restore a 4.1.9 instance to a new cluster running 5.1.x ?
Hello,
We've finally got to the stage where we can migrate an existing 4.1.x instance to new hardware (with a different naming convention). The backup.sh script is fine if restoring to the original hosts but not to new ones.
Is there an approved (or at least tested) way of doing this ?
Many thanks
Pete
We've finally got to the stage where we can migrate an existing 4.1.x instance to new hardware (with a different naming convention). The backup.sh script is fine if restoring to the original hosts but not to new ones.
Is there an approved (or at least tested) way of doing this ?
Many thanks
Pete
0
Comments
./copy_vertica_database.sh -s vertica1 -t vertdb1 -d FARM2
Failed to find database FARM2 on target host vertdb1
The database must exist on the target host.
Where
vertica@vertica1:~/scripts$ ../bin/vsql -h vertdb1 -d FARM2 -U vert
Password:
Welcome to vsql, the Vertica Analytic Database v4.1.9-0 interactive terminal.
Type: \h for help with SQL commands
\? for help with vsql commands
\g or terminate with semicolon to execute query
\q to quit
FARM2=>
clearly works.