On Thursday, December 22, 2011 8:29:11 am Andrus wrote: > Adrian and Bèrto, > > Thank you very much for quick and excellent replies. Locale names are > different in every Linux distro. > Postgresql does not provide any way to retrieve them (ssh access is reqired > to retireve them using locale -a) > > Thus suggection using hard coded locale names is not possible. > > How to force server to use et_EE.UTF-8 as default locale without hard > coding it into application? What application? > > How to force command > > CREATE DATABASE <yourdbname> TEMPLATE = template0 > > to use et_EE.UTF-8 locale by default ? Well you would use template0 as the TEMPLATE only if you wanted to CREATE a database with different collation than that in template1(the default template for the CREATE DATABASE command). So the question then is, why is the database cluster being created with a collation of en_US.UTF-8 when the locale is supposed to have been set to et_EE.UTF-8? First are you sure that dpkg-reconfigure locales is actually resetting the locale? Second when you connect to the cluster with psql what does \l show for encoding and collation? > > Andrus. -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general