Re: A smaller default postgresql.conf
Bruce Momjian <bruce@momjian.us>
From: Bruce Momjian <bruce@momjian.us>
To: Joshua Drake <jd@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Robert Treat <xzilla@users.sourceforge.net>, pgsql-hackers@postgresql.org, Peter Eisentraut <peter_e@gmx.net>, Magnus Hagander <magnus@hagander.net>, Alvaro Herrera <alvherre@commandprompt.com>, Hans-Juergen Schoenig <postgres@cybertec.at>
Date: 2008-08-20T04:10:35Z
Lists: pgsql-hackers
Attachments
- (unnamed) (text/plain)
Joshua Drake wrote: > On Tue, 19 Aug 2008 23:32:34 -0400 > Tom Lane <tgl@sss.pgh.pa.us> wrote: > > > Bruce Momjian <bruce@momjian.us> writes: > > > On idea is for postgresql.conf to merely include other files: > > > include 'sharedmem.conf' > > > include 'compat.conf' > > > ... > > > > That would definitely add complexity ... what would it buy in return? > > I am not arguing for this but if we went down that route it does buy us > the ability to compartmentalize the entire conf.. so you have: > > memory_settings.conf > logging.conf > maintenance.conf > > It is a bit of misdirection as people will open one conf to find a > bunch of pointers to others. Well, I used to have a huge /etc/profile but now it is short and has lines like; . /etc/profile.tty . /etc/profile.env I find when I then edit the subfiles the contents are more uniform and I can underestand it better. As an example, I have attached a suggested Postgres logging.conf file. > Another option would be to break up the conf like the above but do not > include any of them in the main postgresql.conf (which is how I would > argue it should be done). Thus if you want to modify logging, you > "include" it in the postgresql.conf but you make your adjustments in > logging.conf. The problem then is that they modify the logging.conf file and then wonder why the change doesn't take effect. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +