The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

How to backup a database to restore to another server?

Hi,

I have a 3 node cluster i want to backup from cluster and restore to a single node installation. what is the steps for this? vbr.py script can be used? 

Thanks
Najeeb

Comments

  • HI,

    The cluster to which you are restoring the backup should have the same number of nodes as the one used to create the snapshot. The node names and the IP addresses must also be identical.

    For more info pleasefollow doc at below link:

    https://my.vertica.com/docs/6.1.x/HTML/index.htm#16026.htm
  • Below are some of the pre-requisites before performing the backup & restore using vbr.py utility from one cluster to another one. 

    Configure the target to allow the source database to connect to it and restore the database. The target cluster must:

    • Have the same number of nodes the source cluster.
    • Have a database with the same name as the source database. The target database can be completely empty.
    • Have the same node names as the source cluster. The nodes names listed in the nodes system tables on both clusters must match.
    • Be accessible from the source cluster. You may need to add the hostnames of the target cluster to the hosts file of the source cluster.
    • Have the same database administrator account, and all nodes must allow a database administrator of the source cluster to login through SSH without a password.
    Kindly go through below documented link for detailed info on this.

    https://my.vertica.com/docs/6.1.x/HTML/index.htm#16027.htm

    Regards
    Rahul
  • i want to restore to single node vertica server not same number of nodes.
  • You cannot currently restore to a different number of nodes. 

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.