Package: postgis Version: 3.5.2+dfsg-1
Severity: important Architecture: arm64 Dear Maintainer, When trying to enable the PostGIS extension on a fresh PostgreSQL 17 installation running on Debian Trixie (arm64 / Raspberry Pi 5), the database throws the following error: ERROR: invalid byte sequence for encoding "UTF8": 0x00 We tracked this down to a physical null-byte (\x00) inside the SQL extension script provided by the package. File: /usr/share/postgresql/17/extension/postgis--3.5.2.sql Location: Inside the definition string for EPSG 8796 (around the string "AUTHORITY["EPSG","42") Running the following command confirms the physical presence of the null-byte in the file: grep -Pa '\x00' /usr/share/postgresql/17/extension/postgis--3.5.2.sql Workaround: Removing the null-byte with 'tr -d "\000"' and manually fixing the resulting unterminated string/syntax errors at the end of the file allowed the extension to load successfully. It seems there was a compilation or packaging error when building this specific version for arm64. Best regards, Roland Wagner Gemini helped me, its really a great tool. Many thanks also to you, because you maintain also a great tool! [Dein Name]
