SHUTDOWN

Function

SHUTDOWN is used to shut down the currently connected database node.

Precautions

Only the user with the administrator permission can run this command.

Syntax

SHUTDOWN 
  { 
          | 
    fast  | 
    immediate
  };

Parameter Description

• ""

  If the shutdown mode is not specified, the default mode fast is used.

• fast

  Rolls back all active transactions, forcibly disconnects the client, and shuts down the database node without waiting for the client to disconnect.

• immediate

  Shuts down the server forcibly. Fault recovery will occur on the next startup.

Examples

-- Shut down the current database node.
postgres=# SHUTDOWN;

-- Shut down the current database node in fast mode.
postgres=# SHUTDOWN FAST;