Stopping the server quickly
There are different modes available to stop the PostgreSQL server. Here we will talk about the mode in which we can stop the server quickly.
Getting ready
The pg_ctl
command is used in combination with the stop option in order to stop the PostgreSQL server.
How to do it...
We can use the following command to stop the server quickly on Red Hat-based Linux distributions and other Unix-based systems:
pg_ctl -D /var/lib/pgsql/9.6/data -m fast stop
Here, /var/lib/pgsql/9.6/data
is the location of the data directory.
How it works...
The -m
fast option must be used in order to shut down as quickly as possible. In case of a normal shutdown, PostgreSQL will wait for all users to finish their transactions before halting and on a busy ...
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.