percona / percona/percona-postgresql-operator
[2.7.0]How to configure collation for new databases
@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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.