Re: [COMMITTERS] pgsql/ oc/src/sgml/client-auth.sgml oc/src/sgm

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [COMMITTERS] pgsql/ oc/src/sgml/client-auth.sgml oc/src/sgm
Date: 2001-11-04 18:00:17
Message-ID: 200111041800.fA4I0HF25071@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers pgsql-jdbc

> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > But does this mean that postgresql.conf will be reread globally (i.e., by
> > the postmaster), when the user signals HUP only to a single backend?
>
> No. What it does mean is that ADD/DROP/ALTER USER will cause a global
> reread of the conf files. That is kinda annoying, I agree.
>
> We could avoid this by using a different signal number, but there's a
> shortage of available signals. I was toying with the notion of unifying
> all three of the existing reasons for signalling the postmaster
> (SIGUSR1, SIGUSR2, SIGHUP) into a single child-to-parent signal number,
> say SIGUSR1. A flag array in shared memory could be used to indicate
> what the reason(s) are for the most recent signal. This would actually
> free up one signal number, which seems like a good idea in the long run.
> Comments?

While is not ideal, I am not too concerned that USER commands will
reread all config files. Maybe we should wait to see if anyone reports
a problem with this behavior before adding code to correct it.

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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message darcy 2001-11-04 19:42:13 pgsql/src/interfaces/python pg.py
Previous Message Tom Lane 2001-11-04 16:13:15 Re: [COMMITTERS] pgsql/ oc/src/sgml/client-auth.sgml oc/src/sgm ...

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-11-04 18:08:09 Re: Beta going well
Previous Message Rene Pijlman 2001-11-04 17:44:22 Funny timezone shift causes failure in test suite

Browse pgsql-jdbc by date

  From Date Subject
Next Message Rene Pijlman 2001-11-04 18:54:17 Re: Funny timezone shift causes failure in test suite
Previous Message Rene Pijlman 2001-11-04 17:44:22 Funny timezone shift causes failure in test suite