Re: initdb recommendations

From: Noah Misch <noah(at)leadboat(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: initdb recommendations
Date: 2019-04-06 18:08:39
Message-ID: 20190406180839.GA1921989@rfd.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

On Sat, Apr 06, 2019 at 11:35:44AM +0200, Magnus Hagander wrote:
> On Fri, Apr 5, 2019 at 10:58 PM Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
> > On 2019-04-05 18:11, Jonathan S. Katz wrote:
> > > (There could be an additional discussion about whether or not we want to
> > > change the default behavior for initdb, but I would suggest that a safe
> > > starting point would be to ensure we call this out)
> >
> > I think we should just change the defaults. There is a risk of warning
> > fatigue. initdb does warn about this, so anyone who cared could have
> > gotten the information.
> >
>
> I've been suggesting that for years, so definite strong +1 for doing that.

+1

> If it's something that annoys backend developers who initdb very often, I
> suggest we add an environment variable to override it. But I'm not sure
> that's really necessary -- creating a shell alias or similar is easy to do,
> and most have probably already done so for other reasons.

I, for one, do most initdb runs via a script and wouldn't use such an
environment variable.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2019-04-06 18:59:27 How to query the underlying dictionary i.e. inverse of ts_lexize()
Previous Message Magnus Hagander 2019-04-06 09:35:44 Re: initdb recommendations

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2019-04-06 18:09:21 Re: tableam scan-API patch broke foreign key validation
Previous Message Tom Lane 2019-04-06 18:07:55 tableam scan-API patch broke foreign key validation