Thomas' Tech Tips

Reload PostgreSQL configuration without restarting

14 July 2022 - Thomas Damgaard

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.

Filed under: databases, howto, postgres, postgresql, tips