<p><code>select pg_reload_conf()</code> is a handy command to unnecessary database restarts, it reloads the configuration file with the changes you made. To check if there are no unapplied configuration changes, use <code>select * from pg_file_settings where applied = false</code>. For a better understanding on PostgreSQL configuration parameters, their values and whether or not they require a restart, check: </p>