Restoring the status of your host

When you finish the tutorial, you can restore your host machines to their original state.

When you finish the tutorial, you can restore your host machines to their original state. Use the following instructions to clean up your host and start over from scratch.

Stopping and dropping the database

Follow these steps to stop and/or drop your database. A database must be stopped before it can be dropped.

  1. If connected to the database, disconnect by typing \q.

  2. In the Administration Tools Main Menu dialog box, click Stop Database and click OK.

  3. In the Select database to stop window, select the database you want to stop and click OK.

  4. After stopping the database, click Configuration Menu and click OK.

  5. Click Drop Database and click OK.

  6. In the Select database to drop window, select the database you want to drop and click OK.

  7. Click Yes to confirm.

  8. In the next window type yes (lowercase) to confirm and click OK.

Alternatively, use the delete_example script, which stops and drops the database:

  1. If connected to the database, disconnect by typing \q.

  2. In the Administration Tools Main Menu dialog box, select Exit.

  3. Log in as the database administrator.

  4. Change to the /examples directory.

    $ cd /opt/vertica/examples
    
  5. Run the delete_example script.

    $ /opt/vertica/sbin/delete_example Vmart
    

Uninstalling Vertica

See Uninstalling Vertica.

Optional steps

You can also choose to:

  • Remove the dbadmin account on all cluster hosts.

  • Remove any example database directories you created.