Gary Wong <gary_wong(at)dot(dot)ca(dot)gov> writes:
> [Environment under in the postgres account]
> $ env
> [Message I get when I run initdb]
> $ initdb -D /usr/local/pgsql/data
> The files belonging to this database system will be owned by user
> This user must also own the server process.
> The database cluster will be initialized with locales
> COLLATE: en_US.ISO8859-15
> CTYPE: en_US.ISO8859-1
> MESSAGES: C
> MONETARY: en_US.ISO8859-15
> NUMERIC: en_US.ISO8859-15
> TIME: en_US.ISO8859-15
> The default database encoding has accordingly been set to LATIN1.
> initdb: encoding mismatch
> The encoding you selected (LATIN1) and the encoding that the
> selected locale uses (LATIN9) do not match. This would lead to
> misbehavior in various character string processing functions.
> Rerun initdb and either do not specify an encoding explicitly,
> or choose a matching combination.
This is not a bug. You've got inconsistent environment settings,
and the error message seems reasonably appropriate for that.
Try making LC_CTYPE match the rest.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2011-06-15 15:16:35|
|Subject: Re: [GENERAL] psql \s not working - OS X |
|Previous:||From: Yann||Date: 2011-06-15 13:00:40|
|Subject: BUG #6061: Progresql.exe memory usage using HOLD cursor.|