Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sRyXd-002gfH-El for pgsql-general@arkaria.postgresql.org; Thu, 11 Jul 2024 18:29:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sRyXb-00H9fA-RD for pgsql-general@arkaria.postgresql.org; Thu, 11 Jul 2024 18:29:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sRyXb-00H9f1-Fv for pgsql-general@lists.postgresql.org; Thu, 11 Jul 2024 18:29:15 +0000 Received: from mout.perfora.net ([74.208.4.194]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sRyXZ-001bFg-6M for pgsql-general@lists.postgresql.org; Thu, 11 Jul 2024 18:29:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=meddatainc.com; s=s1-ionos; t=1720722549; x=1721327349; i=agents@meddatainc.com; bh=gWZrwsqukvVw96fKfU4GlfF0xwtjL/5abIzaSzzu3XU=; h=X-UI-Sender-Class:Date:In-Reply-To:References:MIME-Version: Content-Type:Content-Transfer-Encoding:Subject:To:CC:From: Message-ID:cc:content-transfer-encoding:content-type:date:from: message-id:mime-version:reply-to:subject:to; b=np4JZ/FEbNYthnv+ygeHbfSaQ5ba90WXnobZ3KfY4oS+drZWmJ988Je/F19KMKEN sIbBDRTnOCX5MJiXULmPcMStKZd0oO234yyZoWiioV9fbub1C7RfO6DHNbyJNIkOh 8gnVCRfkHkF08V7negu4mQ7RUZJJvXK8kGyHeegVrMmzO4z7PV09L3ojQqSd3uZeh ZfQdRiN/WUAJ1TP3q0xlhWz5BntMkF/qg8JqA4zyBTxNnMMnvCt4bzB/g6tdyu6A7 P5qpCnHT5KDsQRUjKPksXUzTdvPZ3pkJQNZ0/KwhWAQX0cEJmw5CeS57mcTl9p22P vJRqqUNLLlP4Zj1YWg== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from [192.168.105.230] ([96.245.190.98]) by mrelay.perfora.net (mreueus003 [74.208.5.2]) with ESMTPSA (Nemesis) id 0MX2Z8-1sp7Y12nqe-00OkqS; Thu, 11 Jul 2024 20:29:09 +0200 Date: Thu, 11 Jul 2024 14:28:49 -0400 User-Agent: K-9 Mail for Android In-Reply-To: <2194461.1720722043@sss.pgh.pa.us> References: <21E2962B-6905-462C-8C12-6E9454CD26FC@meddatainc.com> <97d1dbfd-6e7b-4019-828f-489ccd6e7eae@aklaver.com> <2194461.1720722043@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Subject: Re: Running psql in a docker container To: pgsql-general@lists.postgresql.org,Tom Lane CC: Adrian Klaver From: H Message-ID: X-Provags-ID: V03:K1:I3o9hktsvv9RjtdcLJawvIxLMrtVL9lQ2lyenFL1aTSoJS3c/E9 g/kP+W9y5Hd3gtrhMpq9afMHCdDTlGke8IFsb4R20Q8UFFBzSOnqZzLP0LcykLplYQTWCqL eI0dDZpreKnQlYJc5LzWl0cxW9Ib1qAbPwPjJJm0THzC80vgyW02BfZe0rLhb9NmwoT4K+R xnY6kQwfWl/QOFzmsPBJg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:W49nD61iQ9U=;/73eUhHwJcYTQjaQbdgFr/8Nl3M QQBEbJNOZ2kG76tppxHJ4F3LLDLzME4kKBdl0ifsHWRUyFM/LA5l4D7e1ujoV/XAT5h3wKz8m +9RAyR4KG43gWxZA+4tyIWfvbITPcAN0LpDU0VqAlx3RIdh1pdw/4rHTR48KM+geLx7ObW2vT uMBDu6Ox3DcDSDGjxHiDQh/lUmO+FwC4lc6l89K6Y8Zas5pw/3TzrcCtDzl+S9eCM+KFEFu/Y Xb00OTaAp3rtSMYLFt0OPaomFr8Bb+qzmk9488hHDNT2Z9d43BOYf6n6GAzJeAHHydVsRcory JiXTSPumg6RVDX4JfeqxS9/ln9shUKqToVezyCPfy9p/06R4ifCtPcrIUyukC1QlHR2G4Qb52 O3e85pA+5RTaRkBcc7EBVlEwfRXHHy/r2VVENdN7x61VJYKAJ547yn4QPp3G783d7aEFLwkz+ CqPK1I71SSCF4T6E5vAISQ5tXLbl3cHmizNDayUJSvGEyY1QhGwoMbg1s+5XlDy0OP+61K2ZD yn1HS2LXlO/YQ0Ai8grWNx0xMNvp/RFWZMvnLFRgFm2km3XdRZ/PlBl64ffRWV+CTm84KZ0IW 9BEsR9g00al/g8ac/ZQVvVKVXdMzQGvgZUbkAaXaJkgG+IHGz4jCF6AgfGNDV+fcBGd+d0Vqy HYzcmN3IeOaEVd5DTGLyRV8gNrxagNkar2nmoSFYiWnq0yIAj144155ARPYHIFLkxJLiCefNL jpNfvy68A6gYHWIkdhJVnYm1hCFHcpzJw== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On July 11, 2024 2:20:43 PM EDT, Tom Lane wrote: >H writes: >> Good question! =E2=80=9DNo success=E2=80=9D meant that I have not been = able to figure >out how to have new databases default to en_US=2EUTF-8, instead they >default to C=2EUTF-8=2E > >The default for an installation is determined at initdb time, either >with an explicit locale switch or from the environment locale >settings=2E > > regards, tom lane Understood but how should formulate the initdb statement to accomplish wha= t I want on pgsql 16 since the syntax I used for pgsql 13 does not work in = my container?