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


backup not working after changing ip — Vertica Forum

backup not working after changing ip

Hi,

I have 3 node cluster and a backup server, it was working fine.

I have changed the ip of all nodes and the cluster is working fine now but backup is not working.

when i run vbr.py i am getting an error 


dbadmin@vertica1:~$ /opt/vertica/bin/vbr.py --task backup --config-file /home/dbadmin/fullbak.ini
Preparing...
Found Database port:  5433
Password:
Password:
ssh: connect to host xx.xx.xx.110 port 22: Connection timed out
Unable to ssh to host: xx.xx.xx.xx.110
backup failed!

"


This xx.xx.xx.110 is old ip of node2  i have recreated ini file but no change.

what should i do to fix this?

Thanks,
Najeeb

Comments

  • Hi,

    Are you using vbr.py ? if yes you need to change the config file or if you want just create a new one. The configuration file is the one that you specify with the option --config-file xxx.ini

    Here is the example of ini file:



    snapshotName = backup_test
    verticaConfig = True
    restorePointLimit = 1
    tempDir = /tmp/vbr
    retryCount = 2
    retryDelay = 1

    [Database]
    dbName = myvertica612
    dbUser = dbadmin

    [Transmission]
    encrypt = False
    checksum = False
    port_rsync = 50000
    bwlimit = 0

    [Mapping0]
    dbNode = v_myvertica612_node0001
    backupHost = 10.50.50.120
    backupDir = /home/dbadmin/mybackup
    [Mapping1]
    dbNode = v_myvertica612_node0002
    backupHost = 10.50.50.120
    backupDir = /home/dbadmin/mybackup
    [Mapping2]
    dbNode = v_myvertica612_node0003
    backupHost = 10.50.50.120
    backupDir = /home/dbadmin/mybackup
    [Mapping3]
    dbNode = v_myvertica612_node0004
    backupHost = 10.50.50.120
    backupDir = /home/dbadmin/mybackup
    [Mapping4]
    dbNode = v_myvertica612_node0005
    backupHost = 10.50.50.120
    backupDir = /home/dbadmin/mybackup
    [Mapping5]
    dbNode = v_myvertica612_node0006
    backupHost = 10.50.50.120
    backupDir = /home/dbadmin/mybackup


    Please let us know how it goes.


    Regards,

    Bhawana
  • Hi Bhavana,

    Please read my problem ,

    I have already recreated ini file.

    This is asking for old ip of node 2.

    Thanks,
    Najeeb


Leave a Comment

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