Re: Simple postgresql.conf wizard - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Simple postgresql.conf wizard
Date
Msg-id Pine.GSO.4.64.0811131924250.10918@westnet.com
Whole thread Raw
In response to Re: Simple postgresql.conf wizard  ("Robert Haas" <robertmhaas@gmail.com>)
List pgsql-hackers
On Thu, 13 Nov 2008, Robert Haas wrote:

>>        listen_addresses = '*'
>
> This doesn't seem like a good thing to autogenerate from a security
> perspective.  I think we should not attempt to guess the user's
> requirements in this area.

Yeah, I don't want to be the guy who flips the switch for being less 
secure by default.  Particularly because it's unlikely to do anything by 
itself--need some changes to pg_hba.conf in most cases.  However, not 
setting listen_addresses to something useful is a common newbie problem. 
I was thinking of producing a warning to standard error with some 
suggestions if listen_addresses isn't set to the usual '*', but not 
actually changing the setting.

>>        max_fsm_pages = DBsize / PageSize / 8
>
> Isn't this moot for 8.4?

At some point this is going to target earlier versions as well so it's 
good to have that intelligence in the app, even if it ends up not being a 
setting that is altered.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Simple postgresql.conf wizard
Next
From: "Robert Haas"
Date:
Subject: Re: array_agg and array_accum (patch)