Robert Treat wrote: > I've always been of the impression that this idea just wont work. For > example, if I set shared_buffers to some number, start my database, then > comment the line out and "reload" my conf file, it just isnt going to reset > to the default. (Or at least to make it do so requires a *lot* more work than > just modifing the guc / conf file mechanisms).
True, but you can't modify shared_buffers anyway unless you restart, so people should realize that. --------------------------------------------------------------------------- > IMHO the suggestion to just uncomment out all of the variables to begin with > would cut down on confusion a great deal and actually be easy to implement, > and as such is probably the way to go for now. > > Robert Treat > > On Wednesday 24 August 2005 15:43, Bruce Momjian wrote: > > OK, TODO updated: > > > > o %Allow commenting of variables in postgresql.conf to restore them > > to defaults > > > > Currently, if a variable is commented out, it keeps the > > previous uncommented value until a server restarted. > > Logically, a reload should set the same values as a > > server restart. > > > > > > --------------------------------------------------------------------------- > > > > Jim C. Nasby wrote: > > > On Wed, Aug 24, 2005 at 03:11:31PM -0400, Greg Stark wrote: > > > > In every other system I've seen, when you "reload" a config file the > > > > system goes through the exact same process (semantically at least) that > > > > it does when starting up. Ie, it start with a fresh slate of defaults > > > > and loads the config file which sets parameters and overrides those > > > > defaults. > > > > > > I think this is a good summary of the desired behavior, and that it > > > should be added to the TODO description. > > > -- > > > Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] > > > Pervasive Software http://pervasive.com 512-569-9461 > > -- > Robert Treat > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
