Vertica configuration informations

salgokriszsalgokrisz Registered User

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 :)

Comments

  • Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert
    edited February 19

    Check the file: /opt/vertica/config/admintools.conf

    Plus these system tables are helpful:

    V_CATALOG.DATABASES
    V_MONTOR.SYSTEM
    V_CATALOG.NODES

  • salgokriszsalgokrisz Registered User

    @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.

  • SruthiASruthiA Employee, Registered User, VerticaExpert

    /opt/vertica/config/admintools.conf will contain some of the information you requested. node IP's, vertica version, port etc.

  • Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert

    Hmm. Didn't I say "Check the file: /opt/vertica/config/admintools.conf"? :p

    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:

    [[email protected] ~]$ 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
    
    [[email protected] ~]$ admintools -t db_status -s UP
    vmart
    
    [[email protected] ~]$ admintools -t db_status -s DOWN
    test,wwt,mydb,up
    
    [[email protected] ~]$ 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
    

Leave a Comment

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