This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a PostgreSQL DBA Function for reloading the Server Configuration flies like postgresql.conf.
Even for small config change, people are restarting the whole server which is not good for existing connections.
And even, all parameters don’t require the restart of the server. You can find this information like which parameter needs config reload in the wiki of PostgreSQL.
So before taking any action, please check the official page.
Now, without restarting the server, you can still reload the configuration files of the PostgreSQL Server.
Use below DBA Function, for reloading the Server Configuration files:
|
1 |
select pg_reload_conf(); |
Leave a Reply