Administrator's guide
This section provides information about commonly performed tasks by the administrator in Vertica.
This section provides information about commonly performed tasks by the administrator in Vertica. It describes how to set up and maintain a database.
Prerequisites
This document makes the following assumptions:
-
You are familiar with the concepts discussed in Architecture.
-
Performed the following procedures as described in Setup:
-
Constructed a hardware platform.
-
Installed Linux.
-
Installed Vertica and configured a cluster of hosts.
-
In this section
- Administration overview
- Managing licenses
- Configuring the database
- Database users and privileges
- Using the administration tools
- Operating the database
- Working with native tables
- Managing client connections
- Projections
- Partitioning tables
- Constraints
- Managing queries
- Transactions
- Database locks
- Using text search
- Managing storage locations
- Analyzing workloads
- Managing the database
- Monitoring the database
- Backing up and restoring the database
- Failure recovery
- Collecting database statistics
- Using diagnostic tools
- Profiling database performance
- About locale
- Appendix: creating native binary format files
- Database management with VCluster
- MCP server