Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rM9cZ-0035pF-EC for pgsql-bugs@arkaria.postgresql.org; Sat, 06 Jan 2024 16:34:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rM9cY-00AHa9-GV for pgsql-bugs@arkaria.postgresql.org; Sat, 06 Jan 2024 16:34:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rM9O2-00AAVH-20 for pgsql-bugs@lists.postgresql.org; Sat, 06 Jan 2024 16:19:02 +0000 Received: from mail-lf1-x131.google.com ([2a00:1450:4864:20::131]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rM9Nz-000Bpj-G6 for pgsql-bugs@lists.postgresql.org; Sat, 06 Jan 2024 16:19:00 +0000 Received: by mail-lf1-x131.google.com with SMTP id 2adb3069b0e04-50e7abe4be4so606072e87.2 for ; Sat, 06 Jan 2024 08:18:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1704557937; x=1705162737; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=CkStSVl0xcbjAHqB5R2SGh88nx/n67UOWJMiCC+sHN0=; b=LQZlAunyFxE5cNnPDZjQqYBNba+xK024B6scpmHfNJAVR9kXJ71aCst/vqy9hkthsf OTSTa8FjyR+akUqwQI1jZpmazLhzy0X8GYgWMqMjLyUewVzN8T5JJQIHWgzFUiuVoAPp WyRbFiQNELiUwIY51pTeCBrNbtcNeaVmhhsMxU1J2tIAOdiy0FYS9z5uXevzSoT1Pb6q wbGiVwWQUEY9l6ECzRbinWIN0mNrZPI5uwVWbKJzIRe5qZISWI0VM0InLChEiv1dPbYW LqrulQg5kMvlTPxoQzMvHIEZLfHEelLPmTu7pb+D0HQ1wrrdlvaMU0DfoxwVXk26m7lv JDaA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1704557937; x=1705162737; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=CkStSVl0xcbjAHqB5R2SGh88nx/n67UOWJMiCC+sHN0=; b=Uobl7zWqkkAWB6EqagiKgubKdenLc7Ftyl3azz9Y/3WweQLpa4flS6OiMrwyGAn/a+ EOVVR9jcpVvDVLdRWI2XOtUxv1SGG6JMcxdLLYTQX/jl0nPj7CDXap9Au/QbSstgYfba XrftwZxgDoNSWeKZ8LC1JyOMm2LCT0KFhOclQPzdWzKW161ftoWstD+d2OmDe451n1K1 SaHf37wx1ASpDtZhBEUP7wTeV6Bexml9DfyhBpYa3RQ5XMlEj48lD0UHXWDyBfHiu0Ww DReskkmqZXFxLyjXa0pNm/4B3FWYnOe/QYTm+bMz9h0MRaz32BO2pip1Ab5u19tX3Lj8 yiIw== X-Gm-Message-State: AOJu0YwA2NxK4jAS/Ye7AFMFqQTB9feE4M/OyGrHn3eQFY0tqwhe6vvi al2OQElkCYJbeN558syh9CfWLiB2AsGhUg== X-Google-Smtp-Source: AGHT+IFd++jfzoJuhWOq6PSoU4QPo6qvqvHKwN2s5BNOrECvgUXao0waGsIAb+7ZF+w5GHOrbPm3fw== X-Received: by 2002:a05:6512:1081:b0:50e:7a04:2222 with SMTP id j1-20020a056512108100b0050e7a042222mr447982lfg.119.1704557936796; Sat, 06 Jan 2024 08:18:56 -0800 (PST) Received: from smtpclient.apple ([176.238.4.228]) by smtp.gmail.com with ESMTPSA id jw17-20020a170906e95100b00a29bd8f9edbsm1039750ejb.72.2024.01.06.08.18.55 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 06 Jan 2024 08:18:56 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-0CF870AF-448A-4E84-A2E7-E39F1D6AC036 Content-Transfer-Encoding: 7bit From: Koray Yavuz Mime-Version: 1.0 (1.0) Subject: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language Date: Sat, 6 Jan 2024 19:18:44 +0300 Message-Id: <6751DF5E-6D6C-4447-ADBC-2332402F5D37@gmail.com> References: Cc: Manika Singhal , Laurenz Albe , pgsql-bugs@lists.postgresql.org In-Reply-To: To: Murat Topcu X-Mailer: iPhone Mail (21C66) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-0CF870AF-448A-4E84-A2E7-E39F1D6AC036 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable There is a solution works for this problem i= n Microsoft Community. I don't know if this is a permanent solution, but it w= orks. 


= Murat Topcu <murat-topcu@outlook.com> =C5=9Funlar=C4=B1 yazd=C4=B1 (6 O= ca 2024 18:43):

=EF=BB=BF

I get the same error when I install update KB5033375.=

 

It gives the same error in the installation I use Ins= taller, postgresql that I downloaded as a zip archive also gives the same er= ror.

 

The postgresql server installed with a working instal= lation before the update gives this error in the windows logs

 

FATAL: configuration file "C:/ProgramData/PostgresDat= a/postgresql.conf" contains errors

 

Postgresql, which I downloaded from the zip and tried= to run, gives the following error in its logs:

 

2024-01-06 18:35:25.438 +03 [28168] LOG: invalid valu= e for parameter "lc_monetary": "Turkish_Turkey.1254"

2024-01-06 18:35:25.439 +03 [28168] LOG: invalid valu= e for parameter "lc_numeric": "Turkish_Turkey.1254"

2024-01-06 18:35:25.440 +03 [28168] LOG: invalid valu= e for parameter "lc_time": "Turkish_Turkey.1254"

2024-01-06 18:35:25.440 +03 [28168] FATAL: configurat= ion file "C:/ProgramData/somePath/anotherPath/postgresql/postgresql.conf" co= ntains errors

 

As a solution, I uninstall the update, but since it i= s a security update, it would be great if a better solution can be found.

 

 

 

Windows i=C3=A7in Posta ile g=C3=B6nderildi

 

Kimden: Manika Singhal
G=C3=B6nderilme: 6 Ocak 2024 Cumartesi 18:28
Kime: Laurenz Albe Bilgi: Koray Yavuz; pgsql-bugs@lists.postgresql.org
Konu: Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for T= urkish language

 

Hi Koray,

 

Thanks for reaching out!

Some other users have also reported this issue after t= he mentioned windows update.

We are trying to reproduce the issue on our side and w= ill provide an update soon.

 

 

-------------------------= -----

Thanks & Regards
Manika Singhal
EnterprisDB Pune

 <= /p>

 



On 03-Nov-2023, at 7:33 PM, Laurenz Albe <laurenz.= albe@cybertec.at> wrote:

 

On Fri, 2023-11-03 at 14:29 +0300, Koray Yavuz wrote= :

Laurenz Albe <laurenz.albe@cybertec.at> =C5=9Funlar=C4=B1 yazd=C4=B1 (3 Ka= s 2023 14:03):
On Fri, 2023-11-03 at 09:13 +0000, PG Bug reporting form wrote:

I just got a new computer, installed clean Windows 1= 1 and all updates.
Before installing the KB5031455 update, I installed PostgreSQL v16. During the installation, I selected "Turkish, Turkey" as the language and it was successful, the service started working. However, after installing the
KB5031455 Update, I could not start the PostgreSQL server service. There was=
the following error in Event Viewer:

"FATAL: configuration file "C:/Program
Files/PostgreSQL/16/data/postgresql.conf" contains errors"
=


This is not a bug.  You added something illegal to "postgresql.conf", and the server refuses to start without a valid configuration.
Edit the file and fix the problem.
The error message should give you details about what was wrong.


No, i did not add anything to postgresql.conf file. Like i said before,
there is a problem with that Windows update.


Hm.  The Windows installer is not maintained by PostgreSQL, but by
EnterpriseDB.  Perhaps one of them is on the list and can comment, but<= br> it is not a PostgreSQL bug that the project can fix.


I installed the update again to double check. When t= he update is installed,
PostgreSQL stops and cannot be started. I saw another error message on the event viewer that Turkish_T=C3=BCrkiye.1254 (it should be Turkish_Turkey.125= 4)
could not be found. As soon as I uninstall the update, the server becomes running again.


Well, perhaps the installer added something problematic to "postgresql.conf"= ?
You didn't quote the literal error message, but I'd search for "T=C3=BCrkiye= ".
Perhaps the "=C3=BC" was in a wrong encoding.

Yours,
Laurenz Albe

 

 

= --Apple-Mail-0CF870AF-448A-4E84-A2E7-E39F1D6AC036--