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