Stopping the server in an emergency
In this recipe, we will show you the command that can be used to stop the server in an emergency situation.
How to do it...
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 /var/lib/pgsql/9.6/data.
How it works...
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 ...
Get PostgreSQL High Performance Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
