Reload Postgres' pg_hba Changes Without Restart

Ever make changes to pg_hba.conf and wish to apply your changes without restarting the Postgres server (impacting users)? Easy! Open a PSQL shell and execute the following query:

Ever make changes to pg_hba.conf and wish to apply your changes without restarting the Postgres server (impacting users)?  Easy!  Open a PSQL shell and execute the following query:

SELECT pg_reload_conf();

Share Tweet Send
0 Comments
Loading...