Reload Postgres config from psql

After you’ve made a change in the Postgres settings you may need to restart the postgres service. The command you would use for this depends on your init system, if you’re using systemd the command sudo service postgresql restart will probably do.

If your change doesn’t require a full restart but just a reload, there is a convenient command available in psql:

postgres=# SELECT pg_reload_conf();
 pg_reload_conf
----------------
 t
(1 row)

See Also

6 Non-Programming Books for Programmers