NetBSD-Users archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

Re: Updating default PostgreSQL server encoding from SQL_ASCII to UTF8



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


Home | Main Index | Thread Index | Old Index