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 1sS0Ng-0034Bn-3x for pgsql-general@arkaria.postgresql.org; Thu, 11 Jul 2024 20:27:08 +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 1sS0Ne-000LeX-Pv for pgsql-general@arkaria.postgresql.org; Thu, 11 Jul 2024 20:27:06 +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 1sS0Ne-000LeP-CU for pgsql-general@lists.postgresql.org; Thu, 11 Jul 2024 20:27:06 +0000 Received: from mout.perfora.net ([74.208.4.196]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sS0Nc-001cA3-1k for pgsql-general@lists.postgresql.org; Thu, 11 Jul 2024 20:27:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=meddatainc.com; s=s1-ionos; t=1720729620; x=1721334420; i=agents@meddatainc.com; bh=AAw6EB4hioNabLeoz56wtBRH0UuJGtFKrLvaCU3kPnQ=; 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=UBgBZQtFpsaXGYrk63+mLHsc1T3DGKpIg2JuFCyrRSrSlLxRF3v6/z6FVUQNSo49 So9OycIGSNvorweQTIH8LHybNDxZi5WirIm6q00pVIIm4eqblJ9v8wf8NdbxfDeTx kXtKGLiO0iIOoVxOJN4mr8ZzqifPPIGys6bV7J9iEEjMkkQ/C/dieU1I2+upQHJaW nw5ctZC5k3HjzOWpzjX1TFYi7SqD6FmzIPPdZNRDFFEYy7fBT/COzZZMCAyYWxmFV ArIezgpxQntU02AHdK7o+mHXGLGdEC2gagV1bgKy2DUagRBVn/ULWOn+vnXLIlIW4 zwZQ0WSiEep+6nIrIg== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from [192.168.105.230] ([96.245.190.98]) by mrelay.perfora.net (mreueus004 [74.208.5.2]) with ESMTPSA (Nemesis) id 1N8Won-1sFCew3jHt-00zcxI; Thu, 11 Jul 2024 22:27:00 +0200 Date: Thu, 11 Jul 2024 16:25:39 -0400 User-Agent: K-9 Mail for Android In-Reply-To: <2204849.1720727322@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> <2204849.1720727322@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:ccZnB8Moqkvx5WO14EcV3gxBmSve6coZRZl/1or6nITgpKylY1f Rl4LwuojZvEssQZQy7dz2aQiEMZtHYW19XVb3CjY9ECk94Q/NKH6+utVV8lO90YmSaFQT4O bhxiIYpn4VdTTm406mrIAlAZZ/jhwzUgNO7sEPb+Qn3j4v8MexqHEtYMQx6t6uhpupfbgHV ps3PWAeg/E9QLrw2CHGzg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:PnKYVtTBXfc=;zI75Opvv5VbC2vN+0SZD3ZD4yTd R5yXE2mX9pA6QAoKZOYGNx2EzTQbsbnio1m+4fBuy4zUmXcXyN2j2stEnqmAOSzQhDGPQgsVT qt/uakrxVZ2LpgBxoTuxo1OlBhCOJOD24dqko9IRr3wEZCVBYmAjXYTrnjl7NVAL9zsJ1FT2c mHe9VCY+Hozk8cao6N0kVLWkQfVhFhAVMiffbSJOl0X0WReEp2CjZ4QfoiOE0Yd1/17ftUqld 8lu7MkS8juqMxRPpSLibDuHGfW5CPM7uxRA9pCAnfPGXPZyrzAjSXs/yYSxCTCeX+ARmdZ/KG HoHeHpUZIKu7Kri/k3VTXOIpTVljpdqq+ybtZp+PGgRm47P0eDkIYRMaBBxb9RNwz2/qsHODI H/seT30lMV2LJL/WpnoVSEdfOdir95x4OXjHgz5Y7nlrtPR4/xXoEdiujq6J3Y0QRcKtxUfXG PFBf6CicQ4yMqYLoDHcBwrrNeiIEm63+gbN3vkUjJdUrAf1lWUqp8XI13Lx1rt9SgjpXcsE7i 1QCgxjx8uFkv0zdTV850xjjAwnhpw2PaFn8QDIbOmrAMLaVPubdaNxkqgSgwhFVFnEs4LvZQ/ AicmdgxKLoh7P8Sb0DiWK7WPp+Q57hWleyXVZ1Vi+Pt1b6s6TUsaLz2KodOsSY50SF/DgqdKf 5c8ghWvNC+DHXtO0pk9FMjcjqcOf5zwoGVhD4cqAfcu+wsILQwhAR3ZKBWdRx5TcTaM9m0Zdz o8ixEw/Pa2HsVX4LWrtO0juyPHc6HWNAQ== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On July 11, 2024 3:48:42 PM EDT, Tom Lane wrote: >H writes: >> Understood but how should formulate the initdb statement to >accomplish what I want on pgsql 16 since the syntax I used for pgsql 13 >does not work in my container? > >You still haven't shown us the actual error message, so we're all >just guessing=2E > >I will offer a guess though=2E This *should* work, since Rocky 9 >is a direct descendant of RHEL/CentOS 7=2E The only reason I can >think why it wouldn't is that you haven't installed the OS package >that defines en_US=2EUTF-8=2E Try doing "locale -a" and see if >en_US=2EUTF-8 is among the listed locales=2E > >On my RHEL8 box, it looks like glibc-locale-source is what >provides most non-C locales=2E > > regards, tom lane I run locale p=C3=A5 in the container and found that the appropriate local= e is called en_US=2Eutf8, ie=2E not en_US=2EUTF-8=2E=2E=2E Problem now solved! Thank you all!