percona
[2.7.0]How to configure collation for new databases
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)
