On Windows 7, I am trying to install PostgreSQL 9.5 (postgresql-9.5.2-1-windows-x64.exe) with different locales, but it is getting installed with default locale only, which is, `English_United States.1252`. I tried both the methods, GUI and unattended/silent, but the results are same.
I followed the below steps:
1. Set the locale of system to the particular locale, for ex. `English, Australia`.
2. Restarted the system.
3. Installed PostgreSQL using following command using parameter `--locale`:
start /w postgresql-9.5.2-1-windows-x64.exe --mode unattended --unattendedmodeui none --superaccount "postgres" --superpassword "postgrespwd" --prefix "C:\Program Files\PostgreSQL\9.5" --datadir "C:\Program Files\PostgreSQL\9.5\data" --serverport "5432" --install_runtimes 1 --locale "English, Australia"
4. Executed the command: `Show lc_collate` and got the output as `English_United States.1252`
Similarly, I followed the same steps while installing through GUI mode (selected option `English, Australia`) and got the same unexpected output.
Here is the important logs from PostgreSQL log file bitrock_installer.log (GUI mode):
Executing cscript //NoLogo "C:\Program Files\PostgreSQL\9.5/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\Program Files\PostgreSQL\9.5" "C:\Program Files\PostgreSQL\9.5\data" 5432 "English, Australia" 0
Script exit code: 0
.
.
.
The database cluster will be initialized with locale "English_United States.1252".
5. When I selected `[Default Locale]` in GUI mode (PostgreSQL 9.5), then only it got installed with `English, Australia` locale. Output of command `Show lc_collate` was `English_Australia.1252`
When I installed PostgreSQL 8.4.8 under same conditions (in GUI mode), there were no issues with that. It got installed with locale English, Australia.
Any idea, what can be the reason behind this?
Thanks and Regards,
Mayank Agrawal
.