Configuration Procedure
This section describes the tasks required to set up an Vertica database. It assumes that you have obtained a valid license key file, installed the Vertica rpm package, and run the installation script as described in Installing Vertica.
You'll complete the configuration procedure using:
-
If you are unfamiliar with Dialog-based user interfaces, read Using the Administration Tools Interface before you begin. See also the Administration Tools Reference for details.
- vsql interactive interface
- Database Designer, described in Creating a Database Design
Note: You can also perform certain tasks using Management Console. Those tasks point to the appropriate topic.
- Follow the configuration procedure in the order presented in this book.
- OpenText strongly recommends that you first use the Tutorial in Getting Started to experiment with creating and configuring a database.
- Although you may create more than one database (for example, one for production and one for testing), you may create only one active database for each installation of Vertica Analytic Database
- The generic configuration procedure described here can be used several times during the development process and modified each time to fit changing goals. You can omit steps such as preparing actual data files and sample queries, and run the Database Designer without optimizing for queries. For example, you can create, load, and query a database several times for development and testing purposes, then one final time to create and load the production database.