Sometimes there are situations where you need a database bounce. This is most likely for the database parameters that require a server restart to come into effect. This is different from the reload option of the server configuration, which only reloads the configuration files without requiring a server bounce.
We can use the following command to restart the database server:
pg_ctl -D /var/lib/pgsql/9.6/data restart
/var/lig/pgsql/9.6/data is the location of the data directory of the PostgreSQL server.
Using the restart mode of the
pg_ctl command first stops the running databases on the PostgreSQL server and then starts the server. It is in effect a two-way process, where ...