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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend