Timescale docker container, cs_CZ locale?

TimescaleDB and PostgreSQL
#1

Hi all,
i’m trying timescale docker container (timescale/timescaledb-ha:pg14-latest).
Is there any way how to setup default locale to cs_CZ and better case insensitive collation?
Thank you a lot.
Ales

#2

I tried to build container as was recommended in official Postgress docker image info. But this does not work either.

FROM timescale/timescaledb-ha:pg14-latest
RUN localedef -i cs_CZ -c -f UTF-8 -A /usr/share/locale/locale.alias cz_CZ.UTF-8
ENV LANG cs_CZ.utf8
#3

Latest progress is this dockerfile:

FROM timescale/timescaledb-ha:pg14-latest
USER root
RUN apt-get update && apt-get install locales-all --reinstall -y
ENV LANG cs_CZ.UTF-8
ENV LANGUAGE cs_CZ:en
ENV LC_ALL cs_CZ.UTF-8

USER postgres

This create new container, where locales are as I need, bud when I start container usind docker compose, then this apears in log :
/docker-entrypoint.sh: line 307: exec: su-exec: not found (edited)

#4

Success :smiley: first I deleted all previously created images, it did not rebuild image by compose file, so while i did change docker file. Docker compose still used an old one.
This is dockerfile from official docker image:

FROM timescale/timescaledb-ha:pg14-latest
USER root
RUN apt-get update && apt-get install locales-all --reinstall -y

ENV LANG cs_CZ.UTF-8  
ENV LANGUAGE cs_CZ:en  
ENV LC_ALL cs_CZ.UTF-8

USER postgres

This will create image with cs_CZ.UTF8 lang. :smile: which can be used to compose and I have collation which I needed.