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.