Re: 7.2 pg_hba.conf load on SIGHUP? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: 7.2 pg_hba.conf load on SIGHUP?
Date
Msg-id 200111160451.fAG4pl306516@candle.pha.pa.us
Whole thread Raw
In response to Re: 7.2 pg_hba.conf load on SIGHUP?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >> Will a HUP cause the child postgres processes to restart as well?
> >> What if a transaction is occuring at the time of the HUP?
>
> > Again, no effect on children of postmaster.
>
> Not so.  The postmaster responds to the signal as soon as it's idle,
> rereads the conf file itself, and rebroadcasts SIGHUP to all its
> children.  The children then reread the conf file immediately after they
> next receive a query from their clients.  See postmaster/postmaster.c
> and tcop/postgres.c.
>
> A lot of the configuration file entries are not allowed to change in a
> running backend, so the children will ignore attempted changes in those
> entries.  But for entries that can be changed on the fly, the response
> is reasonably prompt across the board.

Yes, true.  The specific question was about pg_hba.conf, which only
affects the postmaster.  postgresql.conf is a file read by postmastger
and backends, and that is re-read by children on sighup.

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.2 pg_hba.conf load on SIGHUP?
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] bug or change in functionality in 7.2?