pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedbug report: initdb failure on Microsoft Windows if path to initdb contains special chars
2+ messages / 2 participants
[nested] [flat]
* bug report: initdb failure on Microsoft Windows if path to initdb contains special chars
@ 2025-02-04 13:57 Stöcker Bernhard - aktivweb GmbH <bernhard.stoecker@aktivweb.de>
2025-02-04 15:55 ` Re: bug report: initdb failure on Microsoft Windows if path to initdb contains special chars Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Stöcker Bernhard - aktivweb GmbH @ 2025-02-04 13:57 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Hi,
I’d like to report an issue concerning initdb on Microsoft Windows if running initdb.exe from a directory that contains special chars like German umlauts. The error message is: FATAL: invalid byte sequence for encoding "UTF8": 0xf6 0x63 0x6b
Version used: 17.2 official Windows binaries
Best regards
Bernhard Stöcker
Mit freundlichen Grüßen
Bernhard Stöcker
Fachinformatiker AE
E-Mail: bernhard.stoecker@aktivweb.de<mailto:bernhard.stoecker@aktivweb.de> [aktivweb System- und Datentechnik GmbH] <https://www.aktivweb.de/;
aktivweb System- und Datentechnik GmbH
Arberseestraße 3 fon: 09924/94324-0
94249 Bodenmais fax: 09924/94324-25
Internet: www.aktivweb.de<https://www.aktivweb.de; Hilfe? Fernwartung starten<https://get.teamviewer.com/b58ey5k;
[DOCBOX® - Das Dokumenten-Management-System]<https://www.docbox.eu/;
Geschäftsführer: Maximilian Baumann, Uwe Weikl
Umsatzsteuernummer: DE201913528, Steuernummer: 162 121 501 70, Registergericht Deggendorf HRB 2094
Attachments:
image093961.JPG (image/jpeg, 29.2K) download
view image
image83b0cf.PNG (image/png, 25.7K) download
view image
* Re: bug report: initdb failure on Microsoft Windows if path to initdb contains special chars
2025-02-04 13:57 bug report: initdb failure on Microsoft Windows if path to initdb contains special chars Stöcker Bernhard - aktivweb GmbH <bernhard.stoecker@aktivweb.de>
@ 2025-02-04 15:55 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2025-02-04 15:55 UTC (permalink / raw)
To: Stöcker Bernhard - aktivweb GmbH <bernhard.stoecker@aktivweb.de>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
=?utf-8?B?U3TDtmNrZXIgQmVybmhhcmQgLSBha3RpdndlYiBHbWJI?= <bernhard.stoecker@aktivweb.de> writes:
> I’d like to report an issue concerning initdb on Microsoft Windows if running initdb.exe from a directory that contains special chars like German umlauts. The error message is: FATAL: invalid byte sequence for encoding "UTF8": 0xf6 0x63 0x6b
The directory name contains those, you mean?
Our position on this is that the data directory's path name has to be
valid in the encoding you are selecting for the database. Otherwise
it's just too much of a mess to deal with inside-the-database values
like the data_directory setting. It looks like you are using some
single-byte encoding (probably a Windows code page?) for your
filesystem names, so you should do the same for initdb's -E option.
Or switch to an all-ASCII path name.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-02-04 15:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-04 13:57 bug report: initdb failure on Microsoft Windows if path to initdb contains special chars Stöcker Bernhard - aktivweb GmbH <bernhard.stoecker@aktivweb.de>
2025-02-04 15:55 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox