BUG #16103: Initdb does not respect country for language

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #16103: Initdb does not respect country for language

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      16103
Logged by:          Simon Wimmesberger
Email address:      [hidden email]
PostgreSQL version: 10.10
Operating system:   Windows Server 2008 R2
Description:        

When using the enterprisedb installer on Windows and I select the language
"German, Austria" it is passed to initdb with "German,Austria". When I look
at the database property of the initialized database the "collation" and
"character type" is set to "German_Germany.1252" instead of the expected
value of "German_Austria.1252". When I call initdb directly with
"German_Austria.1252" it works as expected. In our usecase we really want to
use the enterprisedb installer therefore selecting the language should work
as expected.

I have also tried to select "Englisch, Ireland" in the installer it is again
passed to initdb as "English,Ireland" but the database is then wrongly
initialized with "English_United States.1252" - so it seems like that the
installer somehow passes the Language/Country wrong the initdb executable or
initdb does not respect the country when passed in this format.

Reply | Threaded
Open this post in threaded view
|

Re: BUG #16103: Initdb does not respect country for language

Sandeep Thakkar-2
Thanks for reporting, We will look into it.

On Fri, Nov 8, 2019 at 5:45 PM PG Bug reporting form <[hidden email]> wrote:
The following bug has been logged on the website:

Bug reference:      16103
Logged by:          Simon Wimmesberger
Email address:      [hidden email]
PostgreSQL version: 10.10
Operating system:   Windows Server 2008 R2
Description:       

When using the enterprisedb installer on Windows and I select the language
"German, Austria" it is passed to initdb with "German,Austria". When I look
at the database property of the initialized database the "collation" and
"character type" is set to "German_Germany.1252" instead of the expected
value of "German_Austria.1252". When I call initdb directly with
"German_Austria.1252" it works as expected. In our usecase we really want to
use the enterprisedb installer therefore selecting the language should work
as expected.

I have also tried to select "Englisch, Ireland" in the installer it is again
passed to initdb as "English,Ireland" but the database is then wrongly
initialized with "English_United States.1252" - so it seems like that the
installer somehow passes the Language/Country wrong the initdb executable or
initdb does not respect the country when passed in this format.



--
Sandeep Thakkar


Reply | Threaded
Open this post in threaded view
|

Re: BUG #16103: Initdb does not respect country for language

fahar
In reply to this post by PG Bug reporting form
Windows 2008 R2 is not supported platform for PoistgreSQL 10, Please use Windows 2012 and Windows 2016

On Fri, Nov 8, 2019 at 5:15 PM PG Bug reporting form <[hidden email]> wrote:
The following bug has been logged on the website:

Bug reference:      16103
Logged by:          Simon Wimmesberger
Email address:      [hidden email]
PostgreSQL version: 10.10
Operating system:   Windows Server 2008 R2
Description:       

When using the enterprisedb installer on Windows and I select the language
"German, Austria" it is passed to initdb with "German,Austria". When I look
at the database property of the initialized database the "collation" and
"character type" is set to "German_Germany.1252" instead of the expected
value of "German_Austria.1252". When I call initdb directly with
"German_Austria.1252" it works as expected. In our usecase we really want to
use the enterprisedb installer therefore selecting the language should work
as expected.

I have also tried to select "Englisch, Ireland" in the installer it is again
passed to initdb as "English,Ireland" but the database is then wrongly
initialized with "English_United States.1252" - so it seems like that the
installer somehow passes the Language/Country wrong the initdb executable or
initdb does not respect the country when passed in this format.



--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com
Reply | Threaded
Open this post in threaded view
|

Re: BUG #16103: Initdb does not respect country for language

fahar
I also checked tested initdb on supported platform windows 2012 and getting the following message:

C:\Program Files\PostgreSQL\10\bin>initdb.exe -D C:\master1
Die Dateien, die zu diesem Datenbanksystem gehören, werden dem Benutzer
»Fahar Abbas« gehören. Diesem Benutzer muss auch der Serverprozess gehören.

Der Datenbankcluster wird mit der Locale »German_Austria.1252« initialisiert wer
den.
Die Standarddatenbankkodierung wurde entsprechend auf »WIN1252« gesetzt.
Die Standardtextsuchekonfiguration wird auf »german« gesetzt.

Datenseitenprüfsummen sind ausgeschaltet.

erzeuge Verzeichnis C:/master1 ... ok
erzeuge Unterverzeichnisse ... ok
wähle Vorgabewert für max_connections ... 100
wähle Vorgabewert für shared_buffers ... 128MB
wähle Vorgabewert für timezone ... Asia/Karachi
wähle Implementierung von dynamischem Shared Memory ... windows
erzeuge Konfigurationsdateien ... ok
führe Bootstrap-Skript aus ... ok
führe Post-Bootstrap-Initialisierung durch ... ok
synchronisiere Daten auf Festplatte ... ok

WARNUNG: Authentifizierung für lokale Verbindungen auf »trust« gesetzt
Sie können dies ändern, indem Sie pg_hba.conf bearbeiten oder beim
nächsten Aufruf von initdb die Option -A, oder --auth-local und
--auth-host, verwenden.

Erfolg. Sie können den Datenbankserver jetzt mit

    pg_ctl -D ^"C^:^\master1^" -l logdatei start

starten.

It Might possible that you have not set locale properly.

Please find attached the supported platform list for v10.

On Wed, Nov 13, 2019 at 11:19 AM Fahar Abbas <[hidden email]> wrote:
Windows 2008 R2 is not supported platform for PoistgreSQL 10, Please use Windows 2012 and Windows 2016

On Fri, Nov 8, 2019 at 5:15 PM PG Bug reporting form <[hidden email]> wrote:
The following bug has been logged on the website:

Bug reference:      16103
Logged by:          Simon Wimmesberger
Email address:      [hidden email]
PostgreSQL version: 10.10
Operating system:   Windows Server 2008 R2
Description:       

When using the enterprisedb installer on Windows and I select the language
"German, Austria" it is passed to initdb with "German,Austria". When I look
at the database property of the initialized database the "collation" and
"character type" is set to "German_Germany.1252" instead of the expected
value of "German_Austria.1252". When I call initdb directly with
"German_Austria.1252" it works as expected. In our usecase we really want to
use the enterprisedb installer therefore selecting the language should work
as expected.

I have also tried to select "Englisch, Ireland" in the installer it is again
passed to initdb as "English,Ireland" but the database is then wrongly
initialized with "English_United States.1252" - so it seems like that the
installer somehow passes the Language/Country wrong the initdb executable or
initdb does not respect the country when passed in this format.



--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com


--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com

Screen Shot 2019-11-13 at 11.45.44 AM.png (440K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

WG: BUG #16103: Initdb does not respect country for language

Wimmesberger, Simon

Von: Wimmesberger, Simon
Gesendet: Mittwoch, 13. November 2019 08:55
An: 'Fahar Abbas' <[hidden email]>
Betreff: AW: BUG #16103: Initdb does not respect country for language

 

1.       According to this page: https://www.postgresql.org/download/windows/ Windows Server 2008 R2 IS with Postgres 10 supported. I have also tried the same steps as mentioned in the original message with Windows Server 2012 R2 – same outcome

2.       I’m not talking about using initdb with the default settings I’m talking about using the enterprisedb Installer which internally calls initdb with predefined „—locale“ parameters . As I have mentioned calling initdb without locale or with locale „German_Austria.1252“ does indeed work but selecting „German, Austria“ in the enterprisedb installer which then internally calls initdb.exe –locale „German,Austria“ does NOT work.

 

Look at the screenshots in the attachments to get a better idea about the issue.

 

Best Regards,

Simon

 

Von: Fahar Abbas <[hidden email]>
Gesendet: Mittwoch, 13. November 2019 08:05
An: Wimmesberger, Simon <[hidden email]>; [hidden email]
Betreff: Re: BUG #16103: Initdb does not respect country for language

 

NOTICE: This message originates from an external source.


I also checked tested initdb on supported platform windows 2012 and getting the following message:

 

C:\Program Files\PostgreSQL\10\bin>initdb.exe -D C:\master1
Die Dateien, die zu diesem Datenbanksystem gehören, werden dem Benutzer
»Fahar Abbas« gehören. Diesem Benutzer muss auch der Serverprozess gehören.

Der Datenbankcluster wird mit der Locale »German_Austria.1252« initialisiert wer
den.
Die Standarddatenbankkodierung wurde entsprechend auf »WIN1252« gesetzt.
Die Standardtextsuchekonfiguration wird auf »german« gesetzt.

Datenseitenprüfsummen sind ausgeschaltet.

erzeuge Verzeichnis C:/master1 ... ok
erzeuge Unterverzeichnisse ... ok
wähle Vorgabewert für max_connections ... 100
wähle Vorgabewert für shared_buffers .. 128MB
wähle Vorgabewert für timezone ... Asia/Karachi
wähle Implementierung von dynamischem Shared Memory ... windows
erzeuge Konfigurationsdateien ... ok
führe Bootstrap-Skript aus ... ok
führe Post-Bootstrap-Initialisierung durch ... ok
synchronisiere Daten auf Festplatte ... ok

WARNUNG: Authentifizierung für lokale Verbindungen auf »trust« gesetzt
Sie können dies ändern, indem Sie pg_hba.conf bearbeiten oder beim
nächsten Aufruf von initdb die Option -A, oder --auth-local und
--auth-host, verwenden.

Erfolg. Sie können den Datenbankserver jetzt mit

    pg_ctl -D ^"C^:^\master1^" -l logdatei start

starten.

 

It Might possible that you have not set locale properly.

 

Please find attached the supported platform list for v10.

 

On Wed, Nov 13, 2019 at 11:19 AM Fahar Abbas <[hidden email]> wrote:

Windows 2008 R2 is not supported platform for PoistgreSQL 10, Please use Windows 2012 and Windows 2016

 

On Fri, Nov 8, 2019 at 5:15 PM PG Bug reporting form <[hidden email]> wrote:

The following bug has been logged on the website:

Bug reference:      16103
Logged by:          Simon Wimmesberger
Email address:      [hidden email]
PostgreSQL version: 10.10
Operating system:   Windows Server 2008 R2
Description:       

When using the enterprisedb installer on Windows and I select the language
"German, Austria" it is passed to initdb with "German,Austria". When I look
at the database property of the initialized database the "collation" and
"character type" is set to "German_Germany.1252" instead of the expected
value of "German_Austria.1252". When I call initdb directly with
"German_Austria.1252" it works as expected. In our usecase we really want to
use the enterprisedb installer therefore selecting the language should work
as expected.

I have also tried to select "Englisch, Ireland" in the installer it is again
passed to initdb as "English,Ireland" but the database is then wrongly
initialized with "English_United States.1252" - so it seems like that the
installer somehow passes the Language/Country wrong the initdb executable or
initdb does not respect the country when passed in this format.



--

Fahar Abbas

QMG

https://drive.google.com/a/enterprisedb.com/uc?id=0B3A76rNrVTJVNkdxY3hCTU1KUEk&export=download

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com



--

Fahar Abbas

QMG

https://drive.google.com/a/enterprisedb.com/uc?id=0B3A76rNrVTJVNkdxY3hCTU1KUEk&export=download

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com


installer_postgres_support.PNG (112K) Download Attachment
installer_log.PNG (88K) Download Attachment
installer_log_pgadmin.PNG (135K) Download Attachment