Book Contents

Book Index

Next Topic

Home

Starting and Stopping the Database

Starting a Vertica Database

  1. Use View Database Cluster State to make sure that all nodes are down and that no other database is running. If not all nodes are down, see Shutdown Problems.
  2. Use Start Database to start the database.
  3. Check the log files to make sure that no startup problems occurred, as described in Monitoring the Database.
  4. If the startup fails, see Startup Problems.

Stopping a Vertica Database

  1. Use View Database Cluster State to make sure that all nodes are up. If not all nodes are up, see Restarting a Node.
  2. Make sure that there are no open connections to the database. On each host:

    $ netstat | grep 5433

    tcp 0 0 host01:5433 host01:33558 ESTABLISHED

    tcp 0 0 host01:33558 host01:5433 ESTABLISHED

  3. Use Stop Database to stop the database.
  4. If the shutdown fails, see Shutdown Problems.