Hi all!
We are working with vertica DB servers and it is all new for us and we don't know a couple of things. I was looking for the configuration file. but i couldnt find that. Can you please tell me were can i find the basic informations about my server eg: ports open, ip address, version, IP of other nodes in cluster etc...
I am looking for something like the MySQL config file where i can find all the basic informations about my server and the BD on it.
I hope i was clear and you can understand my needs 
Vertica configuration informations
+2Check the file: /opt/vertica/config/admintools.conf
Plus these system tables are helpful:
V_CATALOG.DATABASES
V_MONTOR.SYSTEM
V_CATALOG.NODES
@Jim_Knicely thank you! But can you tell me if is there another way than checking the tables, because our script should check the type of the DB server even when the databases service is not running.
+1/opt/vertica/config/admintools.conf will contain some of the information you requested. node IP's, vertica version, port etc.
+2Hmm. Didn't I say "Check the file: /opt/vertica/config/admintools.conf"? 
Anyway...
@salgokrisz, what do you mean by "type of DB server?" Version?
You can use admintools on the command line to show some useful DB info.
Examples:
[dbadmin@SE-Sandbox-43-node1 ~]$ admintools -t list_allnodes Node | Host | State | Version | DB ------------------+----------------+-------+-----------------+------- v_mydb_node0001 | 192.168.61.227 | DOWN | vertica-9.2.0.3 | mydb v_mydb_node0002 | 192.168.61.228 | DOWN | vertica-9.2.0.3 | mydb v_mydb_node0003 | 192.168.61.229 | DOWN | vertica-9.2.0.3 | mydb v_test_node0001 | 192.168.61.227 | DOWN | vertica-9.2.0.3 | test v_test_node0002 | 192.168.61.228 | DOWN | vertica-9.2.0.3 | test v_test_node0003 | 192.168.61.229 | DOWN | vertica-9.2.0.3 | test v_up_node0001 | 192.168.61.227 | DOWN | vertica-9.2.0.3 | up v_up_node0002 | 192.168.61.228 | DOWN | vertica-9.2.0.3 | up v_up_node0003 | 192.168.61.229 | DOWN | vertica-9.2.0.3 | up v_vmart_node0001 | 192.168.61.227 | UP | vertica-9.2.0.3 | vmart v_vmart_node0002 | 192.168.61.228 | UP | vertica-9.2.0.3 | vmart v_vmart_node0003 | 192.168.61.229 | UP | vertica-9.2.0.3 | vmart v_wwt_node0001 | 192.168.61.227 | DOWN | vertica-9.2.0.3 | wwt v_wwt_node0002 | 192.168.61.228 | DOWN | vertica-9.2.0.3 | wwt v_wwt_node0003 | 192.168.61.229 | DOWN | vertica-9.2.0.3 | wwt [dbadmin@SE-Sandbox-43-node1 ~]$ admintools -t db_status -s UP vmart [dbadmin@SE-Sandbox-43-node1 ~]$ admintools -t db_status -s DOWN test,wwt,mydb,up [dbadmin@SE-Sandbox-43-node1 ~]$ admintools -t list_node -n v_up_node0001 Node Information for v_up_node0001 Symbolic node name: v_up_node0001 Host name: 192.168.61.227 Catalog pathname: /home/dbadmin Data pathname: /home/dbadmin
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
