BUG #16103: Initdb does not respect country for language

Started by PG Bug reporting formover 6 years ago12 messagesbugs

noreply@postgresql.org

over 6 years ago

The following bug has been logged on the website:

Bug reference: 16103
Logged by: Simon Wimmesberger
Email address: simon.wimmesberger@zoetis.com
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

sandeep.thakkar@enterprisedb.com

over 6 years ago

In reply to: PG Bug reporting form (#1)

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

Thanks for reporting, We will look into it.

On Fri, Nov 8, 2019 at 5:45 PM PG Bug reporting form <noreply@postgresql.org>
wrote:

The following bug has been logged on the website:

Bug reference: 16103
Logged by: Simon Wimmesberger
Email address: simon.wimmesberger@zoetis.com
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

Fahar Abbas

fahar.abbas@enterprisedb.com

over 6 years ago

In reply to: PG Bug reporting form (#1)

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

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 <noreply@postgresql.org>
wrote:

The following bug has been logged on the website:

Bug reference: 16103
Logged by: Simon Wimmesberger
Email address: simon.wimmesberger@zoetis.com
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

fahar.abbas@enterprisedb.com

over 6 years ago

In reply to: Fahar Abbas (#3)

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

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 <fahar.abbas@enterprisedb.com>
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 <
noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference: 16103
Logged by: Simon Wimmesberger
Email address: simon.wimmesberger@zoetis.com
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

Wimmesberger, Simon

simon.wimmesberger@zoetis.com

over 6 years ago

In reply to: PG Bug reporting form (#1)

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

Von: Wimmesberger, Simon
Gesendet: Mittwoch, 13. November 2019 08:55
An: 'Fahar Abbas' <fahar.abbas@enterprisedb.com>
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 <fahar.abbas@enterprisedb.com<mailto:fahar.abbas@enterprisedb.com>>
Gesendet: Mittwoch, 13. November 2019 08:05
An: Wimmesberger, Simon <simon.wimmesberger@zoetis.com<mailto:simon.wimmesberger@zoetis.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
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:

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

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 <fahar.abbas@enterprisedb.com<mailto:fahar.abbas@enterprisedb.com>> 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 <noreply@postgresql.org<mailto:noreply@postgresql.org>> wrote:
The following bug has been logged on the website:

Bug reference: 16103
Logged by: Simon Wimmesberger
Email address: simon.wimmesberger@zoetis.com<mailto:simon.wimmesberger@zoetis.com>
PostgreSQL version: 10.10
Operating system: Windows Server 2008 R2
Description:

--
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<http://www.enterprisedb.com>

Wimmesberger, Simon

simon.wimmesberger@zoetis.com

about 6 years ago

In reply to: Sandeep Thakkar (#2)

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

Any updates regarding this issue? This issue unfornutatly makes our work more unconfortable than it should be.

________________________________
Thanks for reporting, We will look into it.

On Fri, Nov 8, 2019 at 5:45 PM PG Bug reporting form <noreply@postgresql.org<mailto:noreply@postgresql.org>> wrote:
The following bug has been logged on the website:

--
Sandeep Thakkar

Fahar Abbas

fahar.abbas@enterprisedb.com

about 6 years ago

In reply to: Wimmesberger, Simon (#6)

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

Hi,

I am getting following when we do initdb with system locale is german
Austria:

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

Datenseitenprüfsummen sind ausgeschaltet.

erzeuge Verzeichnis C:/master ... 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

Erfolg. Sie können den Datenbankserver jetzt mit

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

starten.

C:\Program Files\PostgreSQL\10\bin>

On Wed, Feb 5, 2020 at 1:58 PM Wimmesberger, Simon <
simon.wimmesberger@zoetis.com> wrote:

Any updates regarding this issue? This issue unfornutatly makes our work
more unconfortable than it should be.

* ------------------------------ *

Thanks for reporting, We will look into it.

On Fri, Nov 8, 2019 at 5:45 PM PG Bug reporting form <
noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference: 16103
Logged by: Simon Wimmesberger
Email address: simon.wimmesberger@zoetis.com
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

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

fahar.abbas@enterprisedb.com

about 6 years ago

In reply to: Fahar Abbas (#7)

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

C:\Program Files\PostgreSQL\10\bin>psql.exe -U postgres
Passwort für Benutzer postgres:
psql (10.12)
Warnung: Konsolencodeseite (850) unterscheidet sich von der Windows-
Codeseite (1252). 8-Bit-Zeichen funktionieren möglicherweise nicht
richtig. Einzelheiten finden Sie auf der psql-Handbuchseite unter
»Notes for Windows users«.
Geben Sie »help« für Hilfe ein.

postgres=# show lc_messages;
lc_messages
---------------------
German_Austria.1252
(1 Zeile)

postgres=#

On Tue, Mar 17, 2020 at 12:31 PM Fahar Abbas <fahar.abbas@enterprisedb.com>
wrote:

Hi,

I am getting following when we do initdb with system locale is german
Austria:

C:\Program Files\PostgreSQL\10\bin>initdb.exe -D C:\master
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:/master ... 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^:^\master^" -l logdatei start

starten.

C:\Program Files\PostgreSQL\10\bin>

On Wed, Feb 5, 2020 at 1:58 PM Wimmesberger, Simon <
simon.wimmesberger@zoetis.com> wrote:

Any updates regarding this issue? This issue unfornutatly makes our work
more unconfortable than it should be.

* ------------------------------ *

Thanks for reporting, We will look into it.

On Fri, Nov 8, 2019 at 5:45 PM PG Bug reporting form <
noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference: 16103
Logged by: Simon Wimmesberger
Email address: simon.wimmesberger@zoetis.com
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

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

Wimmesberger, Simon

simon.wimmesberger@zoetis.com

about 6 years ago

In reply to: Fahar Abbas (#8)

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

Hi,

when the system language matches with the language you want to initialize the database with everything works correctly (e.g. selecting system language in the enterprisedb installer). The issue is when you want to initialize the database with a specific language which IS NOT the system language. So you have to configure the system with a different system language than what you later pass to initdb.

Best Regards,

Simon

________________________________
Von: Fahar Abbas <fahar.abbas@enterprisedb.com>
Gesendet: Dienstag, 17. März 2020 08:33
An: Wimmesberger, Simon
Cc: Sandeep Thakkar; pgsql-bugs@lists.postgresql.org
Betreff: Re: BUG #16103: Initdb does not respect country for language

NOTICE: This message originates from an external source.

________________________________

postgres=# show lc_messages;
lc_messages
---------------------
German_Austria.1252
(1 Zeile)

postgres=#

On Tue, Mar 17, 2020 at 12:31 PM Fahar Abbas <fahar.abbas@enterprisedb.com<mailto:fahar.abbas@enterprisedb.com>> wrote:
Hi,

I am getting following when we do initdb with system locale is german Austria:

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:/master ... 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

Erfolg. Sie können den Datenbankserver jetzt mit

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

starten.

C:\Program Files\PostgreSQL\10\bin>

On Wed, Feb 5, 2020 at 1:58 PM Wimmesberger, Simon <simon.wimmesberger@zoetis.com<mailto:simon.wimmesberger@zoetis.com>> wrote:
Any updates regarding this issue? This issue unfornutatly makes our work more unconfortable than it should be.

________________________________
Thanks for reporting, We will look into it.

On Fri, Nov 8, 2019 at 5:45 PM PG Bug reporting form <noreply@postgresql.org<mailto:noreply@postgresql.org>> wrote:
The following bug has been logged on the website:

--
Sandeep Thakkar

#10

Fahar Abbas

fahar.abbas@enterprisedb.com

about 6 years ago

In reply to: Wimmesberger, Simon (#9)

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

Hi,

It's an installer behaviour when you set any system locale then same
lc_messages(from dbserver) will be shown accordingly after complete
installation.

Can you please go through this documentation and maybe you will understand
the exact behaviour?

https://www.postgresql.org/docs/10/locale.html

Can you please share the exact steps to reproduce?

On Tue, Mar 17, 2020 at 1:25 PM Wimmesberger, Simon <
simon.wimmesberger@zoetis.com> wrote:

Hi,

when the system language matches with the language you want to initialize
the database with everything works correctly (e.g. selecting system
language in the enterprisedb installer). The issue is when you want to
initialize the database with a specific language which IS NOT
the system language. So you have to configure the system with a different
system language than what you later pass to initdb.

Best Regards,

Simon

------------------------------
*Von:* Fahar Abbas <fahar.abbas@enterprisedb.com>
*Gesendet:* Dienstag, 17. März 2020 08:33
*An:* Wimmesberger, Simon
*Cc:* Sandeep Thakkar; pgsql-bugs@lists.postgresql.org
*Betreff:* Re: BUG #16103: Initdb does not respect country for language

*NOTICE: This message originates from an external source. *
* ------------------------------ *

C:\Program Files\PostgreSQL\10\bin>psql.exe -U postgres
Passwort für Benutzer postgres:
psql (10.12)
Warnung: Konsolencodeseite (850) unterscheidet sich von der Windows-
Codeseite (1252). 8-Bit-Zeichen funktionieren möglicherweise nicht
richtig. Einzelheiten finden Sie auf der psql-Handbuchseite unter
»Notes for Windows users«.
Geben Sie »help« für Hilfe ein.

postgres=# show lc_messages;
lc_messages
---------------------
German_Austria.1252
(1 Zeile)

postgres=#

On Tue, Mar 17, 2020 at 12:31 PM Fahar Abbas <fahar.abbas@enterprisedb.com>
wrote:

Hi,

I am getting following when we do initdb with system locale is german
Austria:

C:\Program Files\PostgreSQL\10\bin>initdb.exe -D C:\master
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:/master ... 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^:^\master^" -l logdatei start

starten.

C:\Program Files\PostgreSQL\10\bin>

On Wed, Feb 5, 2020 at 1:58 PM Wimmesberger, Simon <
simon.wimmesberger@zoetis.com> wrote:

Any updates regarding this issue? This issue unfornutatly makes our work
more unconfortable than it should be.

* ------------------------------ *

Thanks for reporting, We will look into it.

On Fri, Nov 8, 2019 at 5:45 PM PG Bug reporting form <
noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference: 16103
Logged by: Simon Wimmesberger
Email address: simon.wimmesberger@zoetis.com
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

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

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

#11

Wimmesberger, Simon

simon.wimmesberger@zoetis.com

about 6 years ago

In reply to: Fahar Abbas (#10)

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

Hi,

Steps to reproduce:

1. Download the enterprisedb installer (for postgres 10 for example)
2. Set the system locale of the machine to English US
3. Start the installer
4. Select the Locale German, Austria in the installer
5. Install Postgres
6. Look into the initialized postgres database for the locale property
7. The database is initialized with German, Germany instead of German, Austria even though German, Austria is available as a System Locale

If you look into the logfile of the installer you will see that the installer calls initdb with --locale=German,Austria but as I said above the database is wrongly initialized with German,Germany.
If you call (ON THE SAME SYSTEM) initdb with --locale=German_Austria.1252 it works as expected - the database is initialized with German,Austria.

Best Regards,
Simon

________________________________
Von: Fahar Abbas <fahar.abbas@enterprisedb.com>
Gesendet: Dienstag, 17. März 2020 12:00
An: Wimmesberger, Simon
Cc: Sandeep Thakkar; pgsql-bugs@lists.postgresql.org
Betreff: Re: BUG #16103: Initdb does not respect country for language

NOTICE: This message originates from an external source.

________________________________

Hi,

It's an installer behaviour when you set any system locale then same lc_messages(from dbserver) will be shown accordingly after complete installation.

Can you please go through this documentation and maybe you will understand the exact behaviour?

https://www.postgresql.org/docs/10/locale.html

Can you please share the exact steps to reproduce?

On Tue, Mar 17, 2020 at 1:25 PM Wimmesberger, Simon <simon.wimmesberger@zoetis.com<mailto:simon.wimmesberger@zoetis.com>> wrote:

Hi,

Best Regards,

Simon

________________________________
Von: Fahar Abbas <fahar.abbas@enterprisedb.com<mailto:fahar.abbas@enterprisedb.com>>
Gesendet: Dienstag, 17. März 2020 08:33
An: Wimmesberger, Simon
Cc: Sandeep Thakkar; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Betreff: Re: BUG #16103: Initdb does not respect country for language

NOTICE: This message originates from an external source.

________________________________

postgres=# show lc_messages;
lc_messages
---------------------
German_Austria.1252
(1 Zeile)

postgres=#

On Tue, Mar 17, 2020 at 12:31 PM Fahar Abbas <fahar.abbas@enterprisedb.com<mailto:fahar.abbas@enterprisedb.com>> wrote:
Hi,

I am getting following when we do initdb with system locale is german Austria:

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:/master ... 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

Erfolg. Sie können den Datenbankserver jetzt mit

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

starten.

C:\Program Files\PostgreSQL\10\bin>

________________________________
Thanks for reporting, We will look into it.

On Fri, Nov 8, 2019 at 5:45 PM PG Bug reporting form <noreply@postgresql.org<mailto:noreply@postgresql.org>> wrote:
The following bug has been logged on the website:

--
Sandeep Thakkar

#12

Fahar Abbas

fahar.abbas@enterprisedb.com

about 6 years ago

In reply to: Wimmesberger, Simon (#11)

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

Yes i am able to reproduce it.

lc_message should german_austria instead of german_germany

@Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>

Can you please take a look?

On Tue, Mar 17, 2020 at 4:11 PM Wimmesberger, Simon <
simon.wimmesberger@zoetis.com> wrote:

Hi,

Steps to reproduce:

1. Download the enterprisedb installer (for postgres 10 for example)
2. Set the system locale of the machine to English US
3. Start the installer
4. Select the Locale German, Austria in the installer
5. Install Postgres
6. Look into the initialized postgres database for the locale property
7. The database is initialized with German, Germany instead of German,
Austria even though German, Austria is available as a System Locale

If you look into the logfile of the installer you will see that the
installer calls initdb with --locale=German,Austria but as I said above the
database is wrongly initialized with German,Germany.
If you call (ON THE SAME SYSTEM) initdb with --locale=German_Austria.1252
it works as expected - the database is initialized with German,Austria.

Best Regards,
Simon

------------------------------
*Von:* Fahar Abbas <fahar.abbas@enterprisedb.com>
*Gesendet:* Dienstag, 17. März 2020 12:00
*An:* Wimmesberger, Simon
*Cc:* Sandeep Thakkar; pgsql-bugs@lists.postgresql.org
*Betreff:* Re: BUG #16103: Initdb does not respect country for language

*NOTICE: This message originates from an external source. *
* ------------------------------ *

Hi,

It's an installer behaviour when you set any system locale then same
lc_messages(from dbserver) will be shown accordingly after complete
installation.

Can you please go through this documentation and maybe you will understand
the exact behaviour?

https://www.postgresql.org/docs/10/locale.html

Can you please share the exact steps to reproduce?

On Tue, Mar 17, 2020 at 1:25 PM Wimmesberger, Simon <
simon.wimmesberger@zoetis.com> wrote:

Hi,

when the system language matches with the language you want to initialize
the database with everything works correctly (e.g. selecting system
language in the enterprisedb installer). The issue is when you want to
initialize the database with a specific language which IS NOT
the system language. So you have to configure the system with a different
system language than what you later pass to initdb.

Best Regards,

Simon

------------------------------
*Von:* Fahar Abbas <fahar.abbas@enterprisedb.com>
*Gesendet:* Dienstag, 17. März 2020 08:33
*An:* Wimmesberger, Simon
*Cc:* Sandeep Thakkar; pgsql-bugs@lists.postgresql.org
*Betreff:* Re: BUG #16103: Initdb does not respect country for language

*NOTICE: This message originates from an external source. *
* ------------------------------ *

C:\Program Files\PostgreSQL\10\bin>psql.exe -U postgres
Passwort für Benutzer postgres:
psql (10.12)
Warnung: Konsolencodeseite (850) unterscheidet sich von der Windows-
Codeseite (1252). 8-Bit-Zeichen funktionieren möglicherweise
nicht
richtig. Einzelheiten finden Sie auf der psql-Handbuchseite unter
»Notes for Windows users«.
Geben Sie »help« für Hilfe ein.

postgres=# show lc_messages;
lc_messages
---------------------
German_Austria.1252
(1 Zeile)

postgres=#

On Tue, Mar 17, 2020 at 12:31 PM Fahar Abbas <
fahar.abbas@enterprisedb.com> wrote:

Hi,

I am getting following when we do initdb with system locale is german
Austria:

C:\Program Files\PostgreSQL\10\bin>initdb.exe -D C:\master
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:/master ... 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^:^\master^" -l logdatei start

starten.

C:\Program Files\PostgreSQL\10\bin>

On Wed, Feb 5, 2020 at 1:58 PM Wimmesberger, Simon <
simon.wimmesberger@zoetis.com> wrote:

Any updates regarding this issue? This issue unfornutatly makes our
work more unconfortable than it should be.

* ------------------------------ *

Thanks for reporting, We will look into it.

On Fri, Nov 8, 2019 at 5:45 PM PG Bug reporting form <
noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference: 16103
Logged by: Simon Wimmesberger
Email address: simon.wimmesberger@zoetis.com
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

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

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

BUG #16103: Initdb does not respect country for language

Attachments:

Attachments:

Attachments: