Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_hba.conf reload

pg_hba.conf reload

From
"Thomas F. O'Connell"
Date:
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?

-tfo

Re: pg_hba.conf reload

From
Bruce Momjian
Date:
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

Re: pg_hba.conf reload

From
"Thomas F. O'Connell"
Date:
 > 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.


why the change?

-tfo

Re: pg_hba.conf reload

From
Bruce Momjian
Date:
Thomas F. O'Connell wrote:
>  > 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.
>
>
> why the change?

Performance.  Faster to cache contents.

--
  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