Configuration procedure
This section describes the tasks required to set up a Vertica database. It assumes that you have a valid license key file, installed the Vertica rpm package, and ran the installation script as described.
You complete the configuration procedure using:
-
Administration tools
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.Continuing configuring
Follow the configuration procedure sequentially as this section describes.
Vertica strongly recommends that you first experiment with creating and configuring a database.
You can use this generic configuration procedure several times during the development process, modifying it to fit your 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.
In this section
- Prepare disk storage locations
- Disk space requirements for Vertica
- Disk space requirements for Management Console
- Prepare the logical schema script
- Prepare data files
- Prepare load scripts
- Create an optional sample query script
- Create an empty database
- Create the logical schema
- Perform a partial data load
- Test the database
- Optimize query performance
- Complete the data load
- Test the optimized database
- Implement locales for international data sets
- Using time zones with Vertica
- Change transaction isolation levels