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...
You've successfully subscribed to Tyler Wright
Great! Next, complete checkout for full access to Tyler Wright
Welcome back! You've successfully signed in
Success! Your account is fully activated, you now have access to all content.