Re: Running psql in a docker container

2024-07-12 Thread felix . quintgz
In the docker-compose.yml file it can be passed in the environment variables. POSTGRES_INITDB_ARGS: "--encoding=UTF-8" On Thursday, July 11, 2024 at 10:58:14 AM GMT-4, H wrote: I used to successfully run psql server 13 in a CentOS 7 docker container with CentOS 7 as the host operating syst

Re: Running psql in a docker container

2024-07-11 Thread H
On July 11, 2024 3:31:37 PM EDT, Adrian Klaver wrote: >On 7/11/24 11:14, H wrote: >> On July 11, 2024 11:06:02 AM GMT-04:00, Adrian Klaver > 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

Re: Running psql in a docker container

2024-07-11 Thread H
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

Re: Running psql in a docker container

2024-07-11 Thread Tom Lane
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. I will offer a guess though. This

Re: Running psql in a docker container

2024-07-11 Thread Adrian Klaver
On 7/11/24 11:14, H wrote: On July 11, 2024 11:06:02 AM GMT-04:00, Adrian Klaver 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. I have now upgraded that system to Rocky Linux 9 as the host

Re: Running psql in a docker container

2024-07-11 Thread H
On July 11, 2024 2:20:43 PM EDT, Tom Lane wrote: >H 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 >wi

Re: Running psql in a docker container

2024-07-11 Thread David G. Johnston
On Thu, Jul 11, 2024 at 11:16 AM H wrote: > What is the proper syntax for pgsql 16 for this? I could not get the > example given in the docs to work... > The documentation says this still works: su - postgres -c "/usr/pgsql-16/bin/initdb -D /var/lib/pgsql/16/data/ -E 'UTF-8' --lc-collate='en_U

Re: Running psql in a docker container

2024-07-11 Thread Tom Lane
H 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 l

Re: Running psql in a docker container

2024-07-11 Thread H
On July 11, 2024 11:06:02 AM GMT-04:00, Adrian Klaver 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. I have now >upgraded that system to Rocky Linux 9 as the host operating system and >mod

Re: Running psql in a docker container

2024-07-11 Thread Adrian Klaver
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. 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.

Running psql in a docker container

2024-07-11 Thread H
I used to successfully run psql server 13 in a CentOS 7 docker container with CentOS 7 as the host operating system. 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. I can successfully get the