Re: pg_hba.conf reload

Thomas F. O'Connell wrote:
> is there any way in postgres (7.1.3) to get postgres to source the
> pg_hba.conf file without restarting the database completely?
>
> will any new backend use a modified pg_hba.conf if it is modified while
> postgres is running?
>

In 7.1.X and earlier, pg_hba.conf is reread on every connection request.
7.2.X will requires a sighup to the postmaster to reload pg_hba.conf.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026