Thank you. I try in /etc/login.conf: postgres:\ :lang=de_DE.UTF-8:\ :setenv=LC_COLLATE=de_DE.UTF-8:\ :tc=default:
After the command "initdb --lc-collate=de_DE.UTF-8 -D /var/postgresql/data" i get the following error message: The files belonging to this database system will be owned by user "_postgresql". This user must also own the server process. initdb: invalid locale name "de_DE.UTF-8" initdb: invalid locale name "" initdb: invalid locale name "" initdb: invalid locale name "" The database cluster will be initialized with locales COLLATE: C CTYPE: de_DE.UTF-8 MESSAGES: de_DE.UTF-8 MONETARY: C NUMERIC: C TIME: C The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "german". But i need the COLLATE "de_DE.UTF-8" and get "invalid locale name "de_DE.UTF-8" " What is the problem here and how can i fix this? Regards Alex -- View this message in context: http://openbsd-archive.7691.n7.nabble.com/LC-COLLATE-tp282248p282257.html Sent from the openbsd user - misc mailing list archive at Nabble.com.