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.96) (envelope-from ) id 1woImG-000xVp-1b for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Jul 2026 10:41:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1woImF-00CQmj-1V for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Jul 2026 10:41:43 +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.96) (envelope-from ) id 1wnw5b-008nQy-0W for pgsql-bugs@lists.postgresql.org; Sun, 26 Jul 2026 10:28:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wnw5X-00000000Pdx-3FoF for pgsql-bugs@lists.postgresql.org; Sun, 26 Jul 2026 10:28:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: Content-Transfer-Encoding:MIME-Version:Content-Type:Sender:Content-ID: Content-Description:In-Reply-To:References; bh=vYQglx3KJqqeae3JXmOXvueTc5gOU/TGFunnyJDNBjQ=; b=ZY2WMIC/I4C9dGl0ClTyN8Hdq3 Pt7XaNdl3j7IKahZlEpAt7HMEycKnrLxNyfhYqK/2/OQ207/PnAxxOAORyBm7Al7yD+1AqdmyAEiB ySoSCWcYjqpXKvr34F9h7fFfDx/CDvsCoTYrYnBJgEWpKn5l7DzwMDTMBNiJpPCtcQsn4aNlv88RM Sm9zRPyGqvtMT1ltNI6fWzAHKJ/3cVhqLDiTV/v5NADDy681CdTvy8kLCKpz4/S+H7qyavFmJzw1p Jn+7LjaKAUTz2CLbgvJOYZHY9qEHgkAeuwyB5yB2B5+sS8T8s79WYiMBIg92f+K0CHtbCISig5bLd oK/2HcjA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wnw5W-001M1A-1j for pgsql-bugs@lists.postgresql.org; Sun, 26 Jul 2026 10:28:07 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1wnw5T-00000002zmC-1Thh for pgsql-bugs@lists.postgresql.org; Sun, 26 Jul 2026 10:28:03 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Subject: BUG #19581: Non-UTF8-encoded text in log file To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: redoute@tortenboxer.de Reply-To: redoute@tortenboxer.de, pgsql-bugs@lists.postgresql.org Date: Sun, 26 Jul 2026 10:28:01 +0000 Message-ID: <19581-e1b37ea2556ab74d@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk The following bug has been logged on the website: Bug reference: 19581 Logged by: Redoute Email address: redoute@tortenboxer.de PostgreSQL version: 17.4 Operating system: Windows 11 Description: =20 Internal log messages (e.g. checkpoint messages) are written with CP1252 bytes (0xFC for =C3=BC) instead of UTF-8. Consequently pg_read_file(pg_current_logfile()) fails with invalid byte sequence for encoding "UTF8": 0xfc. SQL error messages in the same log appear correctly encoded. Wrongly encoded log file entry: 2026-07-26 08:26:19 CEST LOG: Checkpoint komplett: 7 Puffer geschrieben (0.0%); 0 WAL-Datei(en) hinzugef=C3=BCgt, 0 entfernt, 0 wiederverwendet; Schreiben=3D0,776 s, Sync=3D0,047 s, gesamt=3D0,864 s; sync. Dateien=3D6, l=E4=AE=A7ste=3D0,019 s, Durchschnitt=3D0.008 s; Entfernung=3D3 kB, Sch=E4= =B4=BAung=3D213 kB; LSN=3D2E4/8A2C65C0, Redo-LSN=3D2E4/8A2C6568 Correctly encoded log file entries in the same file: 2026-07-26 11:36:16 CEST FEHLER: ung=C3=BCltige Byte-Sequenz f=C3=BCr Kodi= erung =C2=BBUTF8=C2=AB: 0xfc 2026-07-26 11:36:16 CEST ANWEISUNG: /*pga4dash*/ SELECT pg_read_file(pg_current_logfile(), 0, 14787); =09 2026-07-26 11:37:54 CEST FEHLER: kann Tabelle netex.authority nicht l=C3=B6schen, weil andere Objekte davon abh=C3=A4ngen 2026-07-26 11:37:54 CEST DETAIL: Sicht netex.operators h=C3=A4ngt von Tabe= lle netex.authority ab Sicht netex.linestat h=C3=A4ngt von Tabelle netex.authority ab 2026-07-26 11:37:54 CEST TIPP: Verwenden Sie DROP ... CASCADE, um die abh=C3=A4ngigen Objekte ebenfalls zu l=C3=B6schen.