Command-line options

QuestDB may be started, stopped and passed configuration options from the command line. On Windows, the QuestDB server can also start an interactive session.

Options

The following sections describe the options that may be passed to QuestDB when starting the server from the command line.

./questdb.sh [start|stop|status] [-d dir] [-f] [-n] [-t tag]

Start

start - starts QuestDB as a service.

OptionDescription
-dExpects a dir directory value which is a folder that will be used as QuestDB's root directory. For more information and the default values, see the default root section below.
-tExpects a tag string value which will be as a tag for the service. This option allows users to run several QuestDB services and manage them separately. If this option is omitted, the default tag will be questdb.
-fForce re-deploying the Web Console. Without this option, the Web Console is cached and deployed only when missing.
-nDo not respond to the HUP signal. This keeps QuestDB alive after you close the terminal window where you started it.
-jWindows only! This option allows to specify a path to JAVA_HOME.
note
  • When running multiple QuestDB services, a tag must be used to disambiguate between services for start and stop commands. There will be conflicting ports and root directories if only the tag flag is specified when starting multiple services. Each new service should have its own config file or should be started with separate port and root directory options.

  • When running QuestDB as Windows service you can check status in both:

    • Windows Event Viewer - look for events with "QuestDB" source in Windows Logs | Application .
    • service log file - $dataDir\log\service-%Y-%m-%dT%H-%M-%S.txt (default is C:\Windows\System32\qdbroot\log\service-%Y-%m-%dT%H-%M-%S.txt )
./questdb.sh start [-d dir] [-f] [-n] [-t tag]

Default root directory

By default, QuestDB's root directory will be the following:

$HOME/.questdb

Stop

stop - stops a service.

OptionDescription
-tExpects a tag string value which to stop a service by tag. If this is omitted, the default tag will be questdb
./questdb.sh stop

Status

status - shows the status for a service.

OptionDescription
-tExpects a tag string value which to stop a service by tag. If this is omitted, the default will be questdb
./questdb.sh status

Install (Windows)

install - installs the Windows QuestDB service. The service will start automatically at startup.

questdb.exe install

Remove (Windows)

remove - removes the Windows QuestDB service. It will no longer start at startup.

questdb.exe remove

Interactive session (Windows)

You can start QuestDB interactively by running questdb.exe. This will launch QuestDB interactively in the active Shell window. QuestDB will be stopped when the Shell is closed.

Default root directory

When started interactively, QuestDB's root directory defaults to the current directory.

Stop

To stop, press Ctrl+C in the terminal or close it directly.