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 1sRvGB-0023Ij-7J for pgsql-general@arkaria.postgresql.org; Thu, 11 Jul 2024 14:59:03 +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 1sRvFB-00Eu9E-Oh for pgsql-general@arkaria.postgresql.org; Thu, 11 Jul 2024 14:58:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sRvFB-00Eu8z-B3 for pgsql-general@lists.postgresql.org; Thu, 11 Jul 2024 14:58:01 +0000 Received: from mout.perfora.net ([74.208.4.196]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sRvF6-001YBR-VD for pgsql-general@lists.postgresql.org; Thu, 11 Jul 2024 14:58:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=meddatainc.com; s=s1-ionos; t=1720709875; x=1721314675; i=agents@meddatainc.com; bh=xUxMdexAUBONOyaCZ3OaGmIFF2XDl9ZeRh67uQOdtMQ=; h=X-UI-Sender-Class:Date:MIME-Version:Content-Type: Content-Transfer-Encoding:Subject:To:From:Message-ID:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=KUTMgA10OLs+hLY6vltRcX8V6+Rhj8TR+dgvcVKyuu7cmpr5b0Hi1pSG5zOwsIe3 eB3EQ/XePzscUYQ2rjAwNb1ztG6nxEQ1nWKvSdGOFR5LEtIWhY+0n76mu/ur9YPjB 5md6QiDwLtofVSRHMl8zieeC8uiL4ZjTAgMPToyygslvIuziPZqhgxFUy+R2ULgea 2Zh/3nG2gaoGJSXgbNVnanRp5ZY80uscGMLBCqIdJugdicz4mmlJbcKf/Cr/+2EcA lWmrv18w89a3oryFnbjDwv4HaRGsyfHBa+is2hfXx3YkcdWKKkP3zsMqU+gkOp851 3Fn+jrrwvaVKpVvPmg== 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 0Lx9Jv-1sKnZi0BaL-00xGmE for ; Thu, 11 Jul 2024 16:57:55 +0200 Date: Thu, 11 Jul 2024 10:57:15 -0400 User-Agent: K-9 Mail for Android MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Subject: Running psql in a docker container To: PostgreSQL Users Mailing List From: H Message-ID: <21E2962B-6905-462C-8C12-6E9454CD26FC@meddatainc.com> X-Provags-ID: V03:K1:8C18nXX9K6OpiqUa8DfALwP9PBs/5RdsFsf0z5TuLCdAzEPOKCW Af6sPHHPs3xqGDTXw7IJ06rQHLvUi0d9eEBeBhQEHHow/tLqjDxv/wi2zTUhe1gDfHErnuN g64Pl2NWK1VXyo45zimiqwrpPmQZC65mE1e3NARF5fOnB/AQQ/BDo/fmYTp2+WYXiYgKatL m+4azhF2oX87t+Uo4CWZg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:NFHefRnBOFU=;k6s1W2njgsRTQ5ZhhbE8NHpYB45 Ts0PmOen9Q10gyiPbGb3qcmnoInnpmvydHmCxDkCPZq+6Imwc4rspVKrLhmjmh9jKv9x2DXwi PZlEuQgULUtH+EqmXwoXFALPCLaLWZE2JrjZj2dv+7KD/7RlOeXNVMSlMTV1esu01NT2687df mve7GIh5B2I7sHdgCatzt280cCaKNse+gjcxZv0naiAMnRmQn2kkOcUud059jIwL9jME3nE9t pYAYfMNdLbg4doXVTHFku7yUr/mEJ7zp6T/LbXuwKqGeqNe7pwSzzti5Pjp5uAcyLNxYWwpaq 1YtUUIYpK5I5wiufFqpqPLgOPBpaCcHglEStPBYvyeYt7py1qn52LHb4DDbL5vay/k5uuIz3h DRr4fwov+ZwXuwKFcXTP+ZI2bzJgVn5iO1+6CMsPy402oFOGvvsWeF2qLXyil2NEMQO8JiFGn CVzjMQWyXEZTtsfbrApI45EJWIyurZHxlBXkt+VSaNwxrPwWlipyNhSMKQ/vHWe6Lw+CnIDDV Z75mWDnRrmFBccp9ufxgJ+PHD1jZHAfTQDpxxLlEU6ljyB+S+ToeVTkFIrFfXzURN4DqVTy8Q zh79yo4wzMO/4IGKvC4PqRfXJ53BWoZ2aLgA3dXrma6cAkRwZG45uYOJeVIWNM8pOZh4ciFyj 9/+jLjNMfmYb22uAhW8VlRBi0gG2jNjBv8R9mEQL5KomcpUD5Qw+OGUSovZrXqpjZ/pqB76j3 UswCtK/j+9bhRKoVFTlMt+EX6MfitRhew== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I used to successfully run psql server 13 in a CentOS 7 docker container wi= th CentOS 7 as the host operating system=2E I have now upgraded that system= to Rocky Linux 9 as the host operating system and modifying my container t= o also use Rocky Linux 9 and psql server 16=2E I can successfully get the container up and running and can connect to it= =2E However, I have not managed to modify the initdb statement to use en_US= =2EUTF-8 for all databases=2E In the old container I used: su - postgres -c "/usr/pgsql-13/bin/initdb -D /var/lib/pgsql/13/data/ -E '= UTF-8' --lc-collate=3D'en_US=2EUTF-8' --lc-ctype=3D'en_US=2EUTF-8'" but this does not work with psql 16=2E I tried: su - postgres -c "/usr/pgsql-16/bin/initdb -D /var/lib/pgsql/16/data/ -E '= UTF-8' --lc-lang=3D'en_US'" and variations thereof with no success=2E Any suggestions on what I have missed? Thank you=2E