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

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. +