Optionally Install vsql Client Application on Non-Cluster Hosts

You can use the Vertica vsql executable image on a non-cluster Linux host to connect to a Vertica database.

  • On Red Hat, CentOS, and SUSE systems, you can install the client driver RPM, which includes the vsql executable. See Installing the Client RPM on Red Hat and SUSE for details.

  • If the non-cluster host is running the same version of Linux as the cluster, copy the image file to the remote system. For example:

    $ scp host01:/opt/vertica/bin/vsql .$ ./vsql

  • If the non-cluster host is running a different version of Linux than your cluster hosts, and that operating system is not Red Hat version 5 64-bit or SUSE 10/11 64-bit, you must install the Vertica server RPM in order to get vsql. Download the appropriate rpm package from the Download tab of the myVertica portal then log into the non-cluster host as root and install the rpm package using the command:

    # rpm -Uvh filename

    In the above command, filename is the package you downloaded. Note that you do not have to run the install_Vertica script on the non-cluster host in order to use vsql.

Notes

  • Use the same Command-Line Options that you would on a cluster host.
  • You cannot run vsql on a Cygwin bash shell (Windows). Use ssh to connect to a cluster host, then run vsql.

vsql is also available for additional platforms. See Installing the vsql Client.