Thread: Server's Locale

Server's Locale

From
"T.J. Adami"
Date:
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."

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.

Does it PostgreSQL 8.3 have a problem or its some unnusual set?


Re: Server's Locale

From
Tom Lane
Date:
"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