4 ms·
"ALTER SYSTEM SET, which enables modifications to postgresql.conf from the SQL command line and from remote clients, easing administration tasks" This is fanta
by bradleysmith 12y ago
"ALTER SYSTEM SET, which enables modifications to postgresql.conf from the SQL command line and from remote clients, easing administration tasks"
This is fantastic. We're always adding and removing ip addresses and restarting the server with each update was a pain.
- icebraining 12y agoWhy did you restart the server? You can just send SIGHUP to have it reload the file without restarting.
- bradleysmith 12y agoHah! Because I'm self-taught, and I didn't know I could. Appreciate it!
- joevandyk 12y agoThere's a number of options that you can change in postgresql without having to restart the whole server. http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.h... explains that you can just do a reload after changing pg_hba.conf. http://www.postgresql.org/docs/9.3/static/config-setting.html http://www.postgresql.org/docs/9.3/static/config-setting.htm... explains more.
- bradleysmith 12y agothanks much, digging through both.
- bradleysmith 12y agoActually, I wasn't restarting the server. The pain was reloading that file, as it would break work that other people were doing at the time. I'm looking into whether modifying the postgresql.conf file from a query line will let us do what we were having a need to do.
- joevandyk 12y agoMake sure to have your backup routine archive the custom config file.