Connecting From the Administration Tools

You can use the Administration Tools to connect to a database using vsql on any node in the cluster.

If you are not on the Administration Host, or if you are not logged into the Database Administrator account, you can use Connect to Database but do not perform any other administrative tasks such as configuration.

1. Log in as any user that does not have root privileges. (Vertica does not allow users with root privileges to connect to a database for security reasons).
2. Run the Administration Tools.

   /opt/vertica/bin/adminTools

3. On the Main Menu, select Connect to Database.

   

4. Supply the database password if asked:

   Password:

   The Administration Tools maintain a session context with regard to password authentication. In other words, you are required to enter a password for a database once per Administration Tools session. If you enter it correctly, you will not be asked to enter it again until the next time you run the Administration Tools. If you enter an incorrect password you must exit the Administration Tools and run it again.

5. The Administration Tools connect to the database and transfer control to vsql.

   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.

   Welcome to the vsql, Vertica_Database v2.1.GA interactive terminal.

   Type: \h for help with SQL commands

   \? for help with vsql commands

   \g or terminate with semicolon to execute query

   \q to quit

   Stock_Schema=>