[2.7.0]How to configure collation for new databases

[leefeipo]

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)