In fresh Debian installation default system locale is set to et_EE.UTF-8 using
dpkg-reconfigure locales Postgres is installed using apt-get update apt-get -t squeeze-backports install postgresql-9.1 postgresql-common postgresql-contrib Trying to create database with et_EE.UTF-8 collation and character type returns error --------------------------- pgAdmin III --------------------------- An error has occurred: ERROR: new collation (et_EE.UTF-8) is incompatible with the collation of the template database (en_US.UTF-8) HINT: Use the same collation as in the template database, or use template0 as template. How to create new database with et_EE.UTF-8 collation and character type ? How to force Postgres installation to create template1 with et_EE.UTF-8 collation and character type ? Andrus.
