| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Per-database and per-user GUC settings |
| Date: | 2002-02-01 05:28:41 |
| Message-ID: | 200202010528.g115Sfj25904@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > 1. postgresql.conf contains a setting for some variable, say
> > sort_mem=1000. DBA starts postmaster with a command-line option to
> > override the variable, say --sort_mem=2000. Works fine, until he
> > SIGHUPs the postmaster for some unrelated reason, at which point
> > sort_mem snaps back to 1000.
>
> This sort of thing was once considered a feature, until someone came along
> and overloaded SIGHUP for unreleated things. ;-)
I agree we should not propagate config changes to children on SIGHUP.
The only major question I had was that command-line flags get wiped out
by postgresql.conf settings on SIGHUP. I know someone pointed this
out but has a solution been proposed? That would surprise any admin.
--
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lincoln Yeoh | 2002-02-01 05:43:44 | Re: timestamp weirdness |
| Previous Message | Thomas Lockhart | 2002-02-01 04:14:02 | Re: timestamp weirdness |