How to uninstall Vertica database

To uninstall Vertica:

For each host in the cluster, do the following:

  • Choose a host machine and log in as root (or log in as another user and switch to root).
  • $ su - root
    password: <root-password>
  • Find the name of the package that is installed:
  • rpm -qa | grep vertica
  • Remove the package:
  • # rpm -e package
  • If you want to delete the configuration file used with your installation, you can choose to delete the /opt/vertica/directory and all subdirectories using this command:
  • # rm -rf /opt/vertica/

    For each client system, do the following:

  • Delete the JDBC driver jar file.
  • Delete ODBC driver data source names.
  • Delete the ODBC driver software. On Windows, go to Start > Control Panel > Add or Remove Programs and look for Vertica. Click Remove.