Reload PostgreSQL configuration without restarting

Most changes to PostgreSQL configuration can be applied from an SQL query without restarting the Postgres server. To reload configuration changes from an SQL query without interrupting database operations, start psql as the postgres user and run:

SELECT pg_reload_conf();

This is extremely handy when making changes to pg_hba.conf or similar.