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
Restore Vertica Server
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Restore Vertica Server
Please try reading the documentation
Checkout vertica.tips for more Vertica resources.
Re: Restore Vertica Server
I do but nothing help me.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Restore Vertica Server
You cannot restore an object-level backup after removing nodes, altering node names, or changing IP addresses.
Checkout vertica.tips for more Vertica resources.
Re: Restore Vertica Server
It's impossivel to recovery my data?
Re: Restore Vertica Server
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Fri May 08, 2015 4:36 pm, edited 1 time in total.
Re: Restore Vertica Server
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,
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,