How to change cl_collate and lc-ctype in psql

Hello,

I want to create a psql database for one of the server's cpanel user with cl_collate and cl_ctype 'et_EE.UTF-8' but the database cluster is initialized with locale en_US.UTF-8 . So when I tried to create the db i got the folowing error:

createdb tester_asd --owner=tester -T template0 --lc-collate=et_EE.UTF-8 --lc-ctype=et_EE.UTF-8
createdb: unrecognized option `--lc-collate=et_EE.UTF-8'

Is there any way to create new et_EE.UTF-8 db without corrupting already created psql databases of other accounts?


Thanks in advance!
tanelAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
tbsgadiConnect With a Mentor Commented:
The nature of some locale categories is that their value has to be fixed for the lifetime of a database cluster. That is, once initdb has run, you cannot change them anymore. LC_COLLATE and LC_CTYPE are those categories.

http://www.postgresql.org/docs/8.1/static/charset.html

Gary
0
All Courses

From novice to tech pro — start learning today.