Configuration Procedure

This section describes the tasks required to set up a Vertica database.

This section assumes that you have obtained a valid license key file, installed the Vertica rpm package and run the installation script as described in the Installation Guide.

To complete configuration procedure, you will use the:

• Administration Tools (see the Administration Tools Reference for details)

  The tools needed for administering a Vertica database are provided in the form of a graphical user interface that allows you to perform various tasks quickly and easily. The tools also provide a convenient way to connect to a database using vsql. Always run the Administration Tools on the Administration Host if possible.

  vsql is the Vertica implementation of psql, a character-based, interactive, front-end that is part of PostgreSQL and used by other database management systems. It allows you to type in SQL statements and see the results. It also provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks.

  $ /opt/vertica/bin/adminTools

  See the Administration Tools Reference for a complete description.

• vsql interactive interface. If you are unfamiliar with Dialog-based user interfaces, read Using the Graphical User Interface before you begin.

  Dialog is a Linux utility that creates user interfaces to shell scripts or other scripting languages, such as perl. In Vertica V2.1, Dialog is used to implement the Administration Tools, which run in a terminal window.

  vsql is the Vertica implementation of psql, a character-based, interactive, front-end that is part of PostgreSQL and used by other database management systems. It allows you to type in SQL statements and see the results. It also provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks.

  Vertica strongly recommends that you follow the tutorial procedure in the Quick Start to get hands-on experience with the process of configuring a database before you begin this section.