Problems migrating vertica

kaisersosetkaisersoset Registered User

I am trying to migrate vertica database from a Server to another, but the main problem I have is that there´s no connectivity between the nodes. So I can´t try the copycluster option.

I have configured same version, using same dbadmin users and keep same routes to data and catalogs.

I am tryying to take a backup, restore on the new server, but when I try to start the database I get this error:
*** Starting database: drdata ***
Starting nodes:

All nodes to start have failed startup tests. Nothing to do.
Database start up failed. Failed startup tests. Nothing to do.
Press RETURN to continue

Please can you tell me what options could I have to get restore database on a new server?



  • ivankoivanko Registered User

    Hi, I'd like to describe our schema of keeping primary and secondary clusters in sync. Our cluster consists of 5 nodes. Each node holds two storage areas - vertica-data, which holds files of running database and vertica-backup - which is place where does incremental backup into. Vertica-backup folders are NFS exported to relevant nodes in secondary cluster. A separate process does recovery from these NFS exported backup to secondary cluster. Also these mount points are backed up to the tape for DR purposal from nodes of the secondary cluster.

    While the overall scheme of transferring backup locations to target cluster can be done with varying options, it's strictly required (according to documentation) to have number of nodes, network (intra cluster) and storage configurations to be exactly the same.

    Could you please provide the following information?

    • settings
    • select node_name, node_address, export_address, catalog_path From nodes;
    • select node_name,storage_path,storage_usage from disk_storage;
    • select node_name, location_path, location_usage from storage_locations;
  • Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert
    edited May 9

    @kaisersoset - Can you also post your /opt/vertica/log/admintools.log and $DATABASE_DIR/dbLog files from the node where you tried to start the DB?

Leave a Comment

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