In this recipe, we will talk about the command that can be used to reload the server configuration and its parameters.
If any of the server parameters come into effect after reloading the server configuration files, such as
postgresql.conf, then we need to reload the server configuration using the reload option of the
We can use the following command to reload the server configuration on Red Hat-based Linux and Unix distributions:
pg_ctl -D /var/lib/pgsql/9.6/data reload
You can also reload the configuration using the
pg_reload_conf function while still being connected to PostgreSQL .The usage of the
pg_reload_conf function is mentioned as follows:
postgres=# select pg_reload_conf(); ...