Server's Locale

"T.J. Adami" <adamitj@gmail.com> writes:

I'm testing PostgreSQL 8.3-beta 1, and still do not fix this message:
"createdb: database creation failed: ERROR: encoding LATIN1 does not
match server's locale Portuguese_Brazil.1252
DETAIL: The server's LC_CTYPE setting requires encoding WIN1252."

That's intentional.

On PostgreSQL 8.2.5 I'm able to create data dir with initdb and locale
Latin1, and after create individual databases with SQL_ANSI or
UNICODE.

You might've been able to do it, but it wouldn't have worked very well.
We're tired of reading bug reports from people who misconfigure their
databases that way, so we put in a check to prevent it.

regards, tom lane