Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hChk9-0004Uk-TX for pgsql-docs@arkaria.postgresql.org; Sat, 06 Apr 2019 09:36:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hChk7-0003rh-Ir for pgsql-docs@arkaria.postgresql.org; Sat, 06 Apr 2019 09:36:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hChk7-0003ra-3M for pgsql-docs@lists.postgresql.org; Sat, 06 Apr 2019 09:36:07 +0000 Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hChjz-0004gU-GT for pgsql-docs@lists.postgresql.org; Sat, 06 Apr 2019 09:36:05 +0000 Received: by mail-lj1-x22d.google.com with SMTP id p14so7233442ljg.5 for ; Sat, 06 Apr 2019 02:35:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hagander-net.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=WEMERZsXwnuew+73ZHZegAMN2GNZo6UGNUHQmD+pi0c=; b=ES5HifIFhj64kGK98h1opp9S3grMs1ck0SO/CuMb3kRuKl3rbjhjJoRd8MTOztINVP LW6tGIAfosEgeE4KB9xeXmAbo+VRkOLtcrR66ioR7xndL745pyDY1BI5avxh7JLFWGQ4 m6R30Y7P8OvrQPf31gCusrLOK1p0uIB527xecW/ht62n9STU1itH8ulAVpNqxhvERd0k 4WF0641IGjq46mZ4TAeH/+oogq+wSBsJ7pcr0NKR4K4Hpajqp5kXsCy4OFcsrasWMFMt /iRbf/xilDLDyxJQiL2l7+trrZxMiej4WvaeTYTTdqTeSOMw/x9f6T0G3bokqWAk42dx ZxRA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=WEMERZsXwnuew+73ZHZegAMN2GNZo6UGNUHQmD+pi0c=; b=eCWogbXECYe7iwA3ElL/fUUNC+6rd+RpBkA8bpybD4dxWx5wtxt5lh0mFxIDBhbASw uLwviUDOkO7tytmhkq0TKOIcgre6ccn7V6bwaai2UK6sIGkhDzSYGHQNspizFht3kj+Y WEiINClhubBcX/F20bpvS3oX6lbrscHH/kRRiX2E8ZimKmR9phMmshr1Smbiyib9TL+1 n+CKlIkr7DJ3g3TfRUQCDguIdPBH6TcZ+xGT/v6X8LhRLmONHqIJwE/uruir70OCgrFH raIoQM/aNSSQH+iiuO8Lh6uUzPxQBPvHvmQmSwoXLQT1j27tNHnJhFVslkPaoOUHroBV wVAw== X-Gm-Message-State: APjAAAUiy45CG0dTgLoVcL7+pI3l3ZB8sfNqypoSU1/xAVViHcVEn3uS 5xsWH1VTbAcqeZjJ5pO4IgYLRXA7H1DXvd/SMnFMJtiy X-Google-Smtp-Source: APXvYqySPET8vHt+q9bZ3LP4sBb+0R6YT6t0BlMNbleMrmjOZdDu7JLYb8nihYV1+Z3nscQ4+Py7i5SIFgJEFNfH+5s= X-Received: by 2002:a2e:8149:: with SMTP id t9mr10308399ljg.2.1554543356485; Sat, 06 Apr 2019 02:35:56 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Magnus Hagander Date: Sat, 6 Apr 2019 11:35:44 +0200 Message-ID: Subject: Re: initdb recommendations To: Peter Eisentraut Cc: "Jonathan S. Katz" , Pg Docs Content-Type: multipart/alternative; boundary="0000000000008d36340585d95415" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000008d36340585d95415 Content-Type: text/plain; charset="UTF-8" On Fri, Apr 5, 2019 at 10:58 PM Peter Eisentraut < peter.eisentraut@2ndquadrant.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. 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. That said, I think it would make sense to *also* have a warning. And in particular, we should strongly consider backpatching a warning. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/ --0000000000008d36340585d95415 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Fri, Apr 5, 2019 at 10:58 PM Peter= Eisentraut <peter.e= isentraut@2ndquadrant.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 saf= e
> starting point would be to ensure we call this out)

I think we should just change the defaults.=C2=A0 There is a risk of warnin= g
fatigue.=C2=A0 initdb does warn about this, so anyone who cared could have<= br> gotten the information.

I've been s= uggesting that for years, so definite strong=C2=A0+1 for doing that.
<= div>
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 alia= s or similar is easy to do, and most have probably already done so for othe= r reasons.

That said, I think it would make = sense to *also* have a warning. And in particular, we should strongly consi= der backpatching a warning.

--
=C2=A0Magnus Hagander
=C2= =A0Me: https://www.h= agander.net/
=C2=A0Work: https://www.redpill-linpro.com/
--0000000000008d36340585d95415--