Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes: >> Stefan Schwarzer wrote: >>> I am running 10.5, on a MacPro. Postgres version 8.3.1 and got it from >>> macports. > On my system, though, locale does report the full locale, not just > encoding, when I change LANG. Mine too. On my 10.5.2 machine initdb works as expected when I set LANG to en_US.UTF-8. The only way I can reproduce the failure is to *also* set LC_CTYPE to UTF-8 (without any en_US). That strikes me as a configuration error. PG is looking at LC_CTYPE to decide what text search config to select, and of course this value tells it nothing about which language is in use ... regards, tom lane