The Vertica Database Forums

Dear Members of List,

My Server Vertica are Die and i need to restore my backup in new machine but this message are display "Topology changed after backup; cannot restore."

Can Anybody help me?

Thanks

Please try reading the documentation

I do but nothing help me.

It's impossivel to recovery my data?

Hi!

[DELETED]

Is there a way to update the system tables in Vertica 6.1.3?
ex: Select * from nodes;
gives an IP address that needs to be changed to a different one.
May I know the file in "/vertica/data/Vertica_DB/V_Catalog" which is read by the system table "v_catalog.nodes" while I issue the above command.

To give a quick background of what succeeded in doing so far:

It's our development DB (x.x.x.x) IP into which I have restored a Production backup from server (y.y.y.y) IP successfully without any issues.
The development DB is UP and running but on querying " v_catalog.nodes" system table it returns (y.y.y.y) instead of (x.x.x.x).
I guess we need to update the IP address in some file in V_Catalog folder.
####################################################################
dbadmin=> select * from nodes;
node_name | node_id | node_state | node_address | export_address | catalog_path | is_ephemeral
------------------+-------------------+------------+---------------+----------------+-------------------------------------------------------------------------------+--------------
v_samdb_node0001 | 45035996273704980 | UP | y.y.y.y | y.y.y.y. | /vertica/data/Vertica_DB/V_Catalog/DB/v_db_node0001_catalog/Catalog | f
(1 row)


[dbadmin@DEV-VERT01 config]$ /opt/vertica/bin/admintools -t view_cluster
DB | Host | State
-------+------+-------
DEVDB | ALL | UP


[dbadmin@DEV-VERT01 config]$ /opt/vertica/bin/admintools -t node_map
DATABASE | NODENAME | HOSTNAME
--------------------------------------------------------
DEVDB | v_db_node0001 | x.x.x.x

########################################################################################
Though restoring a Vertica DB between two different IPs is not supported. I Would like to know if anybody in this forum
have tried to do what I've done and managed to change the IP address in the " v_catalog.nodes" system table ....

Thanks,