The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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

hdk0310hdk0310
edited November 4 in General Discussion

Hi,

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 :
/vdata/catalog01/VertexDB/v_vertexdb_node0001_catalog/Catalog

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.

Tagged:

Answers

  • 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
Emoji
Image
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.