Specifying Disk Storage Location During Database Creation

When you invoke the Create Database command in the Administration Tools, a dialog box allows you to specify the catalog and data locations. These locations must exist on each host in the cluster and must be owned by the database administrator.

Database data directories

When you click OK, Vertica automatically creates the following subdirectories:

catalog-pathname/database-name/node-name_catalog/data-pathname/database-name/node-name_data/

For example, if you use the default value (the database administrator's home directory) of /home/ for the Stock Exchange example database, the catalog and data directories are created on each node in the cluster as follows:

/home//Stock_Schema/stock_schema_node1_host01_catalog/home//Stock_Schema/stock_schema_node1_host01_data

Notes