PostgreSQL 9.5 showing unexpected behavior when installed with different locale other than default

From: Mayank Agrawal <mayankagr009(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL 9.5 showing unexpected behavior when installed with different locale other than default
Date: 2017-11-09 07:54:38
Message-ID: CAHUTDK47aUX65urha=Nd8ex+5910x8yxo16uxiiWPpW=CzQd_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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

.

Browse pgsql-general by date

  From Date Subject
Next Message Johannes Graën 2017-11-09 08:09:49 Re: Combine multiple text search configuration
Previous Message Shreeyansh Dba 2017-11-09 07:45:38 Re: Can master and slave on different PG versions?