I'm using the "postgresql-9.2.0-1-windows.exe" installer, from Enterprise DB, on a Windows Vista 32-bit computer.
The issue was noticed with the GUI installer, where I chose the local option "English, New Zealand" from a drop-down menu, but the resulting database cluster has "English_United States.1252". With initdb.exe, I see that --locale has unexpected behaviour. I'll present a few examples that each represent key : value, where key is set with --local="key" and value is from the output: The database cluster will be initialized with locale "value". C : C English : English_United States.1252 French : French_France.1252 nonsense : English_United Kingdom.1252 French, Canada : French_France.1252 French_Canada : French_Canada.1252 English, Canada : English_United States.1252 English_New_Zealand : English_United Kingdom.1252 English, New Zealand : English_United States.1252 English_New Zealand : English_New Zealand.1252 There are some interesting interpretations in the above, but I understand they probably depend on the OS (Windows Vista, in this case). In the install-postgresql.log file I see attempts to get a list of available system locales: Executing C:\Users\mwtoews\AppData\Local\Temp\postgresql_installer\getlocales.exe Script exit code: 0 Script output: AfrikaansxxCOMMAxxxxSPxxSouthxxSPxxAfrica=Afrikaans, South Africa AlbanianxxCOMMAxxxxSPxxAlbania=Albanian, Albania ... EnglishxxCOMMAxxxxSPxxCanada=English, Canada ... EnglishxxCOMMAxxxxSPxxNewxxSPxxZealand=English, New Zealand ... EnglishxxCOMMAxxxxSPxxUnitedxxSPxxKingdom=English, United Kingdom EnglishxxCOMMAxxxxSPxxUnitedxxSPxxStates=English, United States ... FrenchxxCOMMAxxxxSPxxCanada=French, Canada FrenchxxCOMMAxxxxSPxxFrance=French, France where it appears that the value after "=" is used to populate the drop-down menu. -Mike -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs