Creating a Database

  1. On the Configuration Menu, click Create Database and then click OK.
  2. Enter the name of the database and an optional comment. Click OK.
  3. Enter a password. See Creating a Database Name and Password for rules.

    If you do not enter a password, you are prompted to indicate whether you want to enter a password. Click Yes to enter a password or No to create a database without a superuser password.

    Caution: If you do not enter a password at this point, superuser password is set to empty. Unless the database is for evaluation or academic purposes, OpenText strongly recommends that you enter a superuser password.

  4. If you entered a password, enter the password again.
  5. Select the hosts to include in the database. The hosts in this list are the ones that were specified at installation time (install_vertica -s).

    Database Hosts

  6. Specify the directories in which to store the catalog and data files.

    Database data directories

    Note: Catalog and data paths must contain only alphanumeric characters and cannot have leading space characters. Failure to comply with these restrictions could result in database creation failure.

    Note: Do not use a shared directory for more than one node. Data and catalog directories must be distinct for each node. Multiple nodes must not be allowed to write to the same data or catalog directory.

  7. Check the current database definition for correctness, and click Yes to proceed.

    CurrentDatabaseDefinition

  8. A message indicates that you have successfully created a database. Click OK.