From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Sisson, David" <David.Sisson@dell.com>
cc: Christophe Pettus <xof@thebuild.com>, Andres Freund <andres@anarazel.de>,
        Tomas Vondra <tomas.vondra@enterprisedb.com>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17757: Not honoring huge_pages setting during initdb causes
 DB crash in Kubernetes
In-reply-to: 
 <LV2PR19MB5765325D85ADB08967725D058EC89@LV2PR19MB5765.namprd19.prod.outlook.com>
References: <17757-dbdfc1f1c954a6db@postgresql.org>
 <4ce40288-5b88-f9fb-ea11-fc932c61472b@enterprisedb.com>
 <1113115.1674343827@sss.pgh.pa.us>
 <127328f2-4e01-e9ec-c9b1-76aef967343f@enterprisedb.com>
 <20230122020826.x6geac6qjiinr66a@awork3.anarazel.de>
 <LV2PR19MB5765BF10D8D3FD015C6011468EC89@LV2PR19MB5765.namprd19.prod.outlook.com>
 <C0176E91-8B71-4CA2-9FCE-B27944040D6D@thebuild.com>
 <LV2PR19MB5765325D85ADB08967725D058EC89@LV2PR19MB5765.namprd19.prod.outlook.com>
Comments: In-reply-to "Sisson, David" <David.Sisson@dell.com>
	message dated "Mon, 23 Jan 2023 19:51:14 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1882150.1674503750.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 23 Jan 2023 14:55:50 -0500
Message-ID: <1882151.1674503750@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1882151.1674503750%40sss.pgh.pa.us>
Precedence: bulk

"Sisson, David" <David.Sisson@dell.com> writes:
> The default is "huge_pages =3D try" which is commented out in the "postg=
resql.conf.sample" file.
> When a consumer like myself turns it off in the standard "postgresql.con=
f" file, it should not be turned on when initdb runs.

What "standard postgresql.conf file"?  There is no such thing until
initdb creates it.

> There is no way to turn it off without altering the sample config file.

Yup, that's exactly why we are having this discussion.

			regards, tom lane