zalando / zalando/postgres-operator

Is there support to use custom LC_COLLATE and LC_CTYPE?

Open
#375 19 comments 8 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement help wanted
Dominant language
Go
Stars
5.2k
Forks
1.1k
Avg merge
2d 16h
Merged PRs (30d)
3

Description

Hi.

Is there support to use custom LC_COLLATE and LC_CTYPE when specifying databases to be created?

It seems the docker image you provide don't support this? I guess you use the PostgreSQL Docker Community library as base for your docker image builds?
E.g this: https://github.com/docker-library/postgres/blob/master/9.6/Dockerfile

I've tried to change the encoding in the manifest like this:

... patroni: initdb: encoding: "UTF8" locale: "nb_NO.UTF8" ....

I managed to build a docker image with support for nb_NO.UTF8 by using the Dockerfile referenced over and adding this:

localedef -i en_US -c -f UTF-8 -A /usr/share/locale/locale.alias en_US.UTF-8; \ localedef -i nb_NO -f UTF-8 nb_NO.UTF-8
But for what I know patroni uses it own docker registry.

So is there a solution for this?

Let me know I should post this issue in the patroni or spilo repo instead of this.

Br,
Lennart

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the manifest's initdb.encoding and initdb.locale settings, then compare their handling with the referenced PostgreSQL 9.6 Dockerfile and its locale-generation commands. Done means custom LC_COLLATE and LC_CTYPE values are supported by the provided image, or the image limitation and required setup are clearly documented.

Written by the indexing model from the issue text.

Assessment

Tech stack
docker, postgresql
Domain
databases, infrastructure
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.