I just tried both C.UTF-8, en_US.UTF-8 and es_ES.ISO8859-1. In all cases PG refuses to init. unsetting them (or using POSIX) will allow creating the cluster ( defaulting to SQL_ASCII)tolstoy# export LC_ALL="C.UTF-8" tolstoy# /etc/rc.d/pgsql oneinitdb Initializing PostgreSQL databases. initdb: error: invalid locale settings; check LANG and LC_* environment variables pg_ctl: database system initialization failed
This works if you use LC_CTYPE instead: `export LC_CTYPE=C.UTF-8' -RVP
