How to change Vertica Storage Location for Catalog files (Location Usage)

edited November 2019 in General Discussion


I have upgraded Linux OEL 7.5 and then reinstalled vertica cluster.
Post installation the storage location got changed to
/home/dbadmin/VertexDB/v_vertexdb_node0001_catalog/Catalog Storage Usage = CATALOG
Earlier it was :

How can i change the Storage location and usage to catalog again .
If i add a new location it will create by default in DATA,TEMP usage. Also it is not allowing to Alter the Label to Catalog.
CREATE LOCATION '/vdata/catalog01/VertexDB/v_vertexdb_node0001_catalog/Catalog' NODE 'v_vertexdb_node0001' ;

SELECT ALTER_LOCATION_USE ('/vdata/catalog01/VertexDB/v_vertexdb_node0001_catalog/Catalog' , 'v_vertexdb_node0001' , 'CATALOG')
[Code: 3777, SQL State: 22023] [Vertica]VJDBC ERROR: Invalid Usage type: CATALOG

Please help.



  • Options
    Nimmi_guptaNimmi_gupta - Select Field - Employee

    The easy way would be
    ln -s
    ln -s /vdata/catalog01/VertexDB/v_vertexdb_node0001_catalog/ /vdata/catalog01/VertexDB/
    Other option is catalog editining and for that you need to open a support case and work with support team.

Leave a Comment

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