Thread: initdb locale WIN1252

initdb locale WIN1252

From
"Abraham, Danny"
Date:

What’s wrong with locale WIN1252 ?

 

Running successfully initdb, but strange warnings show …

 

 

The files belonging to this database system will be owned by user "EMPG".

This user must also own the server process.

 

The database cluster will be initialized with locale English_United States.1252.

The default database encoding has accordingly been set to WIN1252.

The default text search configuration will be set to "english".

 

fixing permissions on existing directory C:/Program Files/BMC Software/Control-M EM 8.0.00/Default/pgsql/Data ... ok

creating subdirectories ... ok

selecting default max_connections ... 100

selecting default shared_buffers ... 32MB

creating configuration files ... ok

creating template1 database in C:/Program Files/BMC Software/Control-M EM 8.0.00/Default/pgsql/Data/base/1 ... initdb: invalid locale name "WIN1252"

initdb: invalid locale name "WIN1252" ç

initdb: invalid locale name "WIN1252" ç

initdb: invalid locale name "WIN1252"

initdb: invalid locale name "WIN1252"

initdb: invalid locale name "WIN1252"

ok

 

Re: initdb locale WIN1252

From
Adrian Klaver
Date:
On Sunday, December 11, 2011 8:30:35 am Abraham, Danny wrote:
> What's wrong with locale WIN1252 ?
>
> Running successfully initdb, but strange warnings show ...
>
>
> The files belonging to this database system will be owned by user "EMPG".
> This user must also own the server process.
>
> The database cluster will be initialized with locale English_United
> States.1252. The default database encoding has accordingly been set to
> WIN1252. The default text search configuration will be set to "english".
>
> fixing permissions on existing directory C:/Program Files/BMC
> Software/Control-M EM 8.0.00/Default/pgsql/Data ... ok creating
> subdirectories ... ok
> selecting default max_connections ... 100
> selecting default shared_buffers ... 32MB
> creating configuration files ... ok
> creating template1 database in C:/Program Files/BMC Software/Control-M EM
> 8.0.00/Default/pgsql/Data/base/1 ... initdb: invalid locale name "WIN1252"
> initdb: invalid locale name "WIN1252" <==
> initdb: invalid locale name "WIN1252" <==
> initdb: invalid locale name "WIN1252"
> initdb: invalid locale name "WIN1252"
> initdb: invalid locale name "WIN1252"
> ok

First did the initdb complete?
If it did what locale are the databases in?
My suspicion is that initdb is looking for English_United States.1252 as the
locale not WIN1252.

--
Adrian Klaver
adrian.klaver@gmail.com