On July 11, 2024 2:20:43 PM EDT, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >H <agents@xxxxxxxxxxxxxx> writes: >> Good question! ”No success” meant that I have not been able to figure >out how to have new databases default to en_US.UTF-8, instead they >default to C.UTF-8. > >The default for an installation is determined at initdb time, either >with an explicit locale switch or from the environment locale >settings. > > regards, tom lane 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?