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 1hCplF-0002Z7-0x for pgsql-docs@arkaria.postgresql.org; Sat, 06 Apr 2019 18:09:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hCpkF-0005iM-Q0 for pgsql-docs@arkaria.postgresql.org; Sat, 06 Apr 2019 18:08:47 +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 1hCpkF-0005iF-7A for pgsql-docs@lists.postgresql.org; Sat, 06 Apr 2019 18:08:47 +0000 Received: from mail-pg1-x544.google.com ([2607:f8b0:4864:20::544]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hCpkB-0007Wq-Pi for pgsql-docs@lists.postgresql.org; Sat, 06 Apr 2019 18:08:45 +0000 Received: by mail-pg1-x544.google.com with SMTP id j26so4829472pgl.5 for ; Sat, 06 Apr 2019 11:08:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=2nfMRfpdBVodaCcfAZqcFh0fyJiEOnKvMENQRxE77fI=; b=SeAcUpMEERfbyjhbMJgCv804UTad+5I6ZglkZBgtC8vz/+NVT9gGbYtYKrHXfj78lU 5tQ1dx6iXrcd8lua/JNcSqB7gYJhrj3Obe9+3CHa4JzEjFdkb9AqdDjwxSaGA606SRSt J1Bz7b84c7M+OPnHjhMNFKaYlueB0p60ql23c= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=2nfMRfpdBVodaCcfAZqcFh0fyJiEOnKvMENQRxE77fI=; b=r+StB3MhBvYMyZO7AciCTmmnOaNeDC/jzjSLdV5/hL8AKvHA0DdjWaez3wDUS3CBjD ZFBtoO/t+v5Jb7njHGAVhReJW9by22P0vlNCqgVIYE3D6PiEv4Pkp+a1348g+bWU3+jV LP1NqpVJTfGH9GOItNakIR9dZ8YqPtipykeCHIgwD0t9WvrInqFv4fjeBbCb97k0NsTx 2guvJ2oSec4BCChak+P8r5CAdQejKIlyvZr71tSRRCVAwPwqSxGfkAemh6Vx9nnhcsm3 ZCp1jJ54eg2gDk0IH2TjcupFdSPIFyRSi0sW6Fyu6jnxXI/WTKBibSxpVTXk9BGjmX4C 0Gjg== X-Gm-Message-State: APjAAAXjnweLSHkMX0DpZ89Rr4EERzQWeRvA2p6bf8LQBISxMdiHsXWL y6dNErmcY4e7dB6aZhpL5fcFjg== X-Google-Smtp-Source: APXvYqwgub08kvCWXiwi6UvtUVUAbKD1afQFlCN3y2RAQrfJStIXuDB0gtX1Ux84p3MhyLGmzCiRDQ== X-Received: by 2002:a62:7591:: with SMTP id q139mr6179766pfc.14.1554574122560; Sat, 06 Apr 2019 11:08:42 -0700 (PDT) Received: from rfd.leadboat.com (108-233-125-46.lightspeed.sntcca.sbcglobal.net. [108.233.125.46]) by smtp.gmail.com with ESMTPSA id p189sm21283731pfg.184.2019.04.06.11.08.41 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sat, 06 Apr 2019 11:08:41 -0700 (PDT) Date: Sat, 6 Apr 2019 11:08:39 -0700 From: Noah Misch To: Magnus Hagander Cc: Peter Eisentraut , "Jonathan S. Katz" , Pg Docs Subject: Re: initdb recommendations Message-ID: <20190406180839.GA1921989@rfd.leadboat.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sat, Apr 06, 2019 at 11:35:44AM +0200, Magnus Hagander wrote: > On Fri, Apr 5, 2019 at 10:58 PM Peter Eisentraut 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.