Date: Thu, 11 Jul 2024 14:14:55 -0400
User-Agent: K-9 Mail for Android
In-Reply-To: <97d1dbfd-6e7b-4019-828f-489ccd6e7eae@aklaver.com>
References: <21E2962B-6905-462C-8C12-6E9454CD26FC@meddatainc.com> <97d1dbfd-6e7b-4019-828f-489ccd6e7eae@aklaver.com>
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,Adrian Klaver <adrian.klaver@aklaver.com>,PostgreSQL Users Mailing List <pgsql-general@lists.postgresql.org>
From: H <agents@meddatainc.com>
Message-ID: <FE769B77-E004-43AE-A9D0-DCAA8A22E757@meddatainc.com>
UI-OutboundReport: notjunk:1;M01:P0:P9G8w4TGIhs=;syJL3OlUasvcmQd0vnMmbBN0Nx9
 RGq37sRE+ZTMhHfYKEHcF4097RMqCWDR/v8LhWCQzV8eLuCkbJh53TWbkKONfHu4cP06yya7P
 3zCpjxWmK2JcJX8Bip0qXFZyXEGfFVHcFrFv8YDLcBPGvrwQO1mXH4jAyO3JkPT10OcTE/yGc
 dAQoU2mwAyX+J91V4dFfJcYjrrT49UFjYilO4jVwRZtvCnhw6K2tgeR74cfFzT86AMAcOFL5R
 YR2dFZEnpGHPuEv4BE60Eeiw9SoyIaPm1WGvrvY0WBQHAugZmL/V7VT2nYX6HDBf/RoiXZSvu
 mH/0YqcMf0T4g9J9f/K5n2QvzxHjuNWRzLGnJD/OF0dChElQ/YkpbfmbLSLR5Y4zaZhYiwpym
 iNbhj/tRmwR5xBY+k+tWhHKN8Se1fuJeaUMnJbT2+4Kaf52CO7VU2J2k7KsyMtTmmklo/u1GT
 9gCdZ2QxY+TBbYpqc6Iglqj5W/HzYdGaWpJJeXTXVeh8xlCoth4xYfsR/StM4MpxfBjIPQK+F
 rwviet57QeuMiOHWItaEEKAqI0RsS5ivM4+UTPFnBsgIA7i1ewFaxpwzRYHiHtXc96Aw8/4TF
 d7CLwTBo9CZoDg8SHawfOBDOeIV/HkfLvpYC6YowBQFdDYMFOFrF8xnxF1LYVJthItBW2wEKV
 +lxEvN4wVGQDfX9IVcbHkg9iUm9xNUs+ijnjnu4kpfJD4Yy+i3WqxQJLvzNA6nvM0jl2xtCt+
 cyviMxKPJOeBPnu5fXUezBs5o5Im28QLA==
Archived-At: <https://www.postgresql.org/message-id/FE769B77-E004-43AE-A9D0-DCAA8A22E757%40meddatainc.com>
Precedence: bulk

On July 11, 2024 11:06:02 AM GMT-04:00, Adrian Klaver <adrian=2Eklaver@akla=
ver=2Ecom> wrote:
>On 7/11/24 07:57, H wrote:
>> I used to successfully run psql server 13 in a CentOS 7 docker
>container with 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 to also use Rocky Linux 9 and psql server 16=2E
>>=20
>> 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
>>=20
>> In the old container I used:
>>=20
>> 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'"
>>=20
>> but this does not work with psql 16=2E I tried:
>>=20
>> su - postgres -c "/usr/pgsql-16/bin/initdb -D /var/lib/pgsql/16/data/
>-E 'UTF-8' --lc-lang=3D'en_US'"
>>=20
>> and variations thereof with no success=2E
>
>Without a definition of what '=2E=2E=2E no success' means there is no rea=
l
>way=20
>to answer this=2E
>
>>=20
>> Any suggestions on what I have missed?
>>=20
>> Thank you=2E
>>=20
>>=20

Good question! =E2=80=9DNo success=E2=80=9D meant that I have not been abl=
e to figure out how to have new databases default to en_US=2EUTF-8, instead=
 they default to C=2EUTF-8=2E

What is the proper syntax for pgsql 16 for this? I could not get the examp=
le given in the docs to work=2E=2E=2E