Thread: PG 8.3.7 initdb -E LATIN1 fails on Windows
Hi, Runnning: initdb -E LATIN1 -D ..... Error: encoding mismatch Used to run fine on 8.2.4 on the same Windows platform. OUTPUT =========== The database cluster will be initialized with locale English_United States.1252. initdb: encoding mismatch The encoding you selected (LATIN1) and the encoding that the selected locale uses (WIN1252) do not match. This would leadto misbehavior in various character string processing functions. Rerun initdb and either do not specify an encoding explicitly, or choose a matching combination. ============ Thanks Danny Abraham
Abraham, Danny wrote: > Hi, > > Runnning: initdb -E LATIN1 -D ..... > > Error: encoding mismatch Right. Try using Win1252 instead of Latin1: initdb -E win1252 ... Or just leave -E out entirely, since it will be picked up by default from the locale setting anyway. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support