In this recipe, we will show you the command that can be used to stop the server in an emergency situation.
We can use the following command to stop the PostgreSQL server in an emergency:
pg_ctl -D /var/lib/pgsql/9.6/data stop -m immediate
Here, the data directory location is defined at
The moment the immediate stop mode is used with the
pg_ctl command, all the users have their transactions aborted and the existing connections are terminated. There is no system checkpoint either and the database basically requires crash recovery at the time of database restart.
In this shutdown mode, the PostgresSQL process will issue a direct
SIGQUIT signal to each of the ...