From: | Joachim Wieland <joe(at)mcknight(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Mott Leroy <mott(at)acadaca(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: logging settings |
Date: | 2006-02-05 20:33:45 |
Message-ID: | 20060205203345.GA3259@mcknight.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Feb 05, 2006 at 07:59:06PM +0100, Martijn van Oosterhout wrote:
> On Sun, Feb 05, 2006 at 07:43:47PM +0100, Joachim Wieland wrote:
> > I propose to change it on the grounds that:
> > - other unix daemons reset their values to defaults before reading
> > conffiles
> But the biggest issue is that not all values can be changed by
> reloading the config files. So for these variables, no amount of
> "making it more obvious" will change the fact that you're not running
> with the values it says in the config file.
Sure, but theres another item on the TODO list...
errmmm, actually it's done:
o -Issue a warning if a change-on-restart-only postgresql.conf value
is modified and the server config files are reloaded
I just notice that Peter has done this yesterday.
> > - lots of people find it unintuitive
> But resetting to defaults on reload doesn't solve the problem due to
> the above issue. Also, once you know it's not that odd.
No, but setting back to defaults commented variables and issuing a note
for those where it is not possible to change the actual value seems to be a
clean solution.
> > - after restarting pgsql you can never be sure that it runs with
> > the same configuration as before even with an unchanged postgresql.conf
> > The mtime of postgresql.conf then makes you think that it has
> > been running fine with these options for the last 3 months so you don't
> > even take a look at the conf file but look for the problem elsewhere...
> I'm sure you could find lots of people to go for a change, it's just
> the mechanism that people don't agree on. What do you think should
> happen to unchangable config values? You can always see what the
> current values are using SHOW ALL.
Yes but I doubt that people like the idea that they have to cross-check SHOW
ALL output with postgresql.conf after reload just to make sure that the
database will come up the next time as it should.
Joachim
--
Joachim Wieland joe(at)mcknight(dot)de
C/ Usandizaga 12 1°B ICQ: 37225940
20002 Donostia / San Sebastian (Spain) GPG key available
From | Date | Subject | |
---|---|---|---|
Next Message | Joachim Wieland | 2006-02-05 20:45:50 | Re: logging settings |
Previous Message | Tom Lane | 2006-02-05 19:37:53 | Re: logging settings |