SHUTDOWN

Shuts down a Vertica database. By default, the shutdown fails if any users are connected. You can check the status of the shutdown operation in the vertica.log file.

Before calling SHUTDOWN, you can close all current user connections and prevent further connection attempts as follows:

  1. Temporarily set configuration parameter MaxClientSessions to 0.
  2. Call CLOSE_ALL_SESSIONS to close all non-dbamin connections.

Syntax

SHUTDOWN ( [ 'false' | 'true' ] )

Parameters

false

Default, returns a message if users are connected and aborts the shutdown.

true

Forces the database to shut down, disallowing further connections.

Privileges

Superuser

Examples

The following command attempts to shut down the database. Because users are connected, the command fails:

=> SELECT SHUTDOWN('false');
NOTICE:  Cannot shut down while users are connected
          SHUTDOWN
-----------------------------
 Shutdown: aborting shutdown
(1 row)

See Also

SESSIONS