Stop a Database

This article explains how to stop a database.

For Exasol 2025.1 and later, you can use Exasol Admin to start and stop databases. For earlier versions, you must use either ConfD or the Administration API.

Prerequisites

There are no prerequisites for this procedure.

Procedure (Exasol Admin)

  1. Log in to Exasol Admin and open the Databases page.

  2. Click on the Stop database icon .

    stop database

    The database status will change from Running to Stopped.

Procedure (command line)

This procedure uses the c4 and confd_client command-line tools in a Linux terminal. For more information about these tools, see Exasol Deployment Tool (c4) and ConfD.

  1. Connect to the cluster operating system (COS) using c4 connect -i PLAY_ID -s cos.

    Example:
    Copy 
    ./c4 connect -i c3275f84 -s cos

    For more information about how to use c4 connect, see How to use c4.

  2. To find the database name when you are connected to COS, use the ConfD job db_list.

    Example:
    Copy 
    confd_client db_list
    - MY_DATABASE

  3. To stop the database, use the ConfD job db_stop with the db_name parameter.

    Example:
    Copy 
    confd_client db_stop db_name: MY_DATABASE

Verification

To verify that the database has stopped, use the ConfD job db_state. If the result is setup, the database is stopped.

Example:
Copy 
confd_client db_state db_name: MY_DATABASE
...
Result:
'setup'