Thread: postgres hab modification without restarting
Hi all! Is it possible to make the postmaster re-read the pg_hba.conf when needed without pg_ctl restarting the database? I think I could send a unix signal to it, it would simly re-read the file and apply the information for new incoming connection requests. I was looking for this info in the documentation and lists but I did not find anything. Thanks, Laszlo
On Mon, 2003-08-25 at 09:15, Hornyak Laszlo wrote: > Hi all! > > Is it possible to make the postmaster re-read the pg_hba.conf when needed > without pg_ctl restarting the database? I think I could send a unix signal > to it, it would simly re-read the file and apply the information for new > incoming connection requests. > I was looking for this info in the documentation and lists but I did not > find anything. > pg_ctl reload sends the signal to reread the config files http://www.postgresql.org/docs/7.3/interactive/app-pg-ctl.html some parameters can only be set at server start http://www.postgresql.org/docs/7.3/interactive/runtime-config.html Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Robert Treat wrote: > On Mon, 2003-08-25 at 09:15, Hornyak Laszlo wrote: > > Hi all! > > > > Is it possible to make the postmaster re-read the pg_hba.conf when needed > > without pg_ctl restarting the database? I think I could send a unix signal > > to it, it would simly re-read the file and apply the information for new > > incoming connection requests. > > I was looking for this info in the documentation and lists but I did not > > find anything. > > > > pg_ctl reload sends the signal to reread the config files > http://www.postgresql.org/docs/7.3/interactive/app-pg-ctl.html > > some parameters can only be set at server start > http://www.postgresql.org/docs/7.3/interactive/runtime-config.html I think the 'postgres' manual page explains the actual signals used. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Hornyak Laszlo wrote: > > Ok, I know this was an RTFM category question, I just didn`t find the > information, but I promiss I will learn more about the proper use of the > unix command 'grep', so next time I will find it easily :) > > I was looking for a `crontab -e`-like editing. It lets edit the file, > checks the format, and installs if changed, doesn`t let user make > failure - for example to forget sending the signal, or writing bad > formated pg_hba.conf. Is there something like that? No. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Ok, I know this was an RTFM category question, I just didn`t find the information, but I promiss I will learn more about the proper use of the unix command 'grep', so next time I will find it easily :) I was looking for a `crontab -e`-like editing. It lets edit the file, checks the format, and installs if changed, doesn`t let user make failure - for example to forget sending the signal, or writing bad formated pg_hba.conf. Is there something like that? Laci On Tue, 26 Aug 2003, Bruce Momjian wrote: > Robert Treat wrote: > > On Mon, 2003-08-25 at 09:15, Hornyak Laszlo wrote: > > > Hi all! > > > > > > Is it possible to make the postmaster re-read the pg_hba.conf when needed > > > without pg_ctl restarting the database? I think I could send a unix signal > > > to it, it would simly re-read the file and apply the information for new > > > incoming connection requests. > > > I was looking for this info in the documentation and lists but I did not > > > find anything. > > > > > > > pg_ctl reload sends the signal to reread the config files > > http://www.postgresql.org/docs/7.3/interactive/app-pg-ctl.html > > > > some parameters can only be set at server start > > http://www.postgresql.org/docs/7.3/interactive/runtime-config.html > > I think the 'postgres' manual page explains the actual signals used. > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 >