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
.
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? |