Skip to main content

Relocating data directory for existing db

  • April 28, 2017
  • 1 reply
  • 6 views

info4km

I didn't see any info on this after searching the forum, so if it's out there I apologize in advance. I currently have a running vertica database that has the data in /data. I want to move the data to another file system. For example /data2. How do I do this correctly so the database knows where to look for the data (assuming I need to move the actual directory manually).

I tried modifying the admintools.conf and then restarting after manually moving the directory, but that didn't quite do it.

Thanks.
KM

1 reply

myfriendbarley
Forum|alt.badge.img
  • Participating Frequently
  • April 28, 2017

Moving data from one FS to another involves updating the data storage location. The latest doc explaining the tasks is here: https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/AdministratorsGuide/StorageLocations/CreatingAndConfiguringStorageLocations.htm
Let us know if this helps.