select pg_reload_conf() is a handy command to unnecessary database restarts, it reloads the configuration file with the cha...

select pg_reload_conf() 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 select * from pg_file_settings where applied = false. For a better understanding on PostgreSQL configuration parameters, their values and whether or not they require a restart, check: