percona / percona/percona-postgresql-operator

[2.7.0]How to configure collation for new databases

Open
#1,328 0 comments 0 reactions 1 assignee View on GitHub

@gkech is already working on this.

Since Oct 31, 2025.

Dominant language
Go
Stars
385
Forks
83
Avg merge
2d 5h
Merged PRs (30d)
39

Description

Hello all,

I am trying to set up a DB on an operator managed cluster with the collation C. But I cannot find any collation/locale related configuration options. The cluster as a whole, as it gets created, only supports en_US.UTF-8 both as an OS locale and DB collation. But I could not find any configuration options to change the cluster defaults either. Probably I am not looking in the right places?

Thanks in advance,
Ralf

now locale settings:
postgres=# SELECT name, setting
FROM pg_settings
WHERE name LIKE 'lc_%' OR name LIKE '%encoding%';
name | setting
-----------------+-------------
client_encoding | UTF8
lc_collate | en_US.utf-8
lc_ctype | en_US.utf-8
lc_messages | en_US.utf-8
lc_monetary | C
lc_numeric | C
lc_time | C
server_encoding | UTF8
(8 rows)

and my expire locale settings:

  name       |  setting   

-----------------+------------
client_encoding | UTF8
lc_collate | C
lc_ctype | en_US.utf8
lc_messages |
lc_monetary | C
lc_numeric | C
lc_time | C
server_encoding | UTF8
(8 rows)

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.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.