Thread: initdb locale WIN1252
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
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