The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Relocating data directory for existing db
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.
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.