3.6. Shutting down the server
Depending on your needs, there are several ways to shut down the database server when your work is done. The differentiation is done by what signal you send to the server process.
- SIGTERM
After receiving SIGTERM, the postmaster disallows new connections, but lets existing backends end their work normally. It shuts down only after all of the backends terminate by client request. This is the Smart Shutdown.
- SIGINT
The postmaster disallows new connections and sends all existing backends SIGTERM, which will cause them to abort their current transactions and exit promptly. It then waits for the backends to exit and finally shuts down the data base. This is the Fast Shutdown.
- SIGQUIT
This is the Immediate Shutdown which will cause the postmaster to send a SIGQUIT to all backends and exit immediately (without properly shutting down the database system). The backends likewise exit immediately upon receiving SIGQUIT. This will lead to recovery (by replaying the WAL log) upon next start-up. This is recommended only in emergencies.
| Caution |
It is best not to use SIGKILL to shut down the postmaster. This will prevent the postmaster from releasing shared memory and semaphores, which you may then have to do by hand. |
> kill -INT `head -1 /usr/local/pgsql/data/postmaster.pid`
The program pg_ctl is a shell script that provides a more convenient interface for shutting down the postmaster.
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.