RESTORE_LOCATION
Restores a storage location that was previously retired with RETIRE_LOCATION.
Syntax
RESTORE_LOCATION ( 'path', 'node' )
Parameters
path |
Specifies where the retired storage location is mounted. |
node |
The Vertica node where the retired location is available. A value of "" (an empty string) means to perform this operation on all nodes. The operation fails if you have dropped any locations. |
Privileges
Effects of Restoring a Previously Retired Location
After restoring a storage location, Vertica re-ranks all of the cluster storage locations. It uses the newly restored location to process queries as determined by its rank.
Monitoring Storage Locations
Disk storage information that the database uses on each node appears in the V_MONITOR.DISK_STORAGE system table.
Examples
The following example shows how to restore the retired storage location on node3
:
=> SELECT RESTORE_LOCATION ('/thirdVerticaStorageLocation/' , 'v_vmartdb_node0004');