Invalid pgml.so binary for version 2.10 amd64 .deb package
Author: mbaakuCreated Jan 23, 2025Updated Mar 17, 2025
Labelsbug
It appears that latest version of postgresql-pgml package for amd64 architecture contains arm architecture instead of:
root@d89727150ffe:/tmp# ls -l *deb
-rw-r--r-- 1 root root 6464636 Jan 17 23:04 postgresql-pgml-15_2.10.0-ubuntu22.04-amd64.deb
-rw-r--r-- 1 root root 6679932 Jul 24 2024 postgresql-pgml-15_2.9.3-ubuntu22.04-amd64.deb
root@d89727150ffe:/tmp# mkdir 2.9.3 2.10.0
root@d89727150ffe:/tmp# dpkg-deb -R postgresql-pgml-15_2.9.3-ubuntu22.04-amd64.deb 2.9.3/
root@d89727150ffe:/tmp# dpkg-deb -R postgresql-pgml-15_2.10.0-ubuntu22.04-amd64.deb 2.10.0/
root@d89727150ffe:/tmp# file 2.9.3/usr/lib/postgresql/15/lib/pgml.so
2.9.3/usr/lib/postgresql/15/lib/pgml.so: ELF 64-bit LSB shared object, x86-64, version 1 (SYSV), dynamically linked, BuildID[xxHash]=844e7dd41c7f973f, not stripped
root@d89727150ffe:/tmp# file 2.10.0/usr/lib/postgresql/15/lib/pgml.so
2.10.0/usr/lib/postgresql/15/lib/pgml.so: ELF 64-bit LSB shared object, ARM aarch64, version 1 (SYSV), dynamically linked, BuildID[xxHash]=8d5f457892531e45, not strippedUnfortunately it is not possible to install earlier version due to lack of indexing in postgresml repository:
E: Version '2.9.3' for 'postgresql-pgml-15' was not found
root@d89727150ffe:/tmp# apt-cache madison postgresql-pgml-15
postgresql-pgml-15 | 2.10.0 | https://apt.postgresml.org jammy/main amd64 PackagesThe only workaround is manual download of the packages and local installation. Could you please take care of it?
Source: postgresml/postgresml