Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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.



  • 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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.