Hi,
Is it possible to restore a backup taken using the vbr.py utility from one cluster (i.e. a staging cluster) and to a new prod cluster. They do not have the same database name. They have the same number of nodes but the nodes have different IP addresses.
I was wondering if I could just edit all the ini files in the backup to point to the new cluster? Or will there be some sort of issue with the Vertica internal tables after the restore?
Recover Backup from One Cluster to Another
Moderator: NorbertKrupa
Recover Backup from One Cluster to Another
Thanks,
Juliette
Juliette
Re: Recover Backup from One Cluster to Another
HI!
It's possible. You can change ip's of nodes in snapshot catalog to another.
How to edit catalog you can read here (if you will need a help with it - ask):
https://community.vertica.com/vertica/t ... ess-14fuee
I recommend to read whole thread, somehow its refers to your question.
PS
>> They do not have the same database name.
And this is can be a problem, depends how Vertica generates OIDs
It's possible. You can change ip's of nodes in snapshot catalog to another.
How to edit catalog you can read here (if you will need a help with it - ask):
https://community.vertica.com/vertica/t ... ess-14fuee
I recommend to read whole thread, somehow its refers to your question.
PS
>> They do not have the same database name.
And this is can be a problem, depends how Vertica generates OIDs