From: | Erwin de Haan <erwin(dot)de(dot)haan(at)calcasa(dot)nl> |
---|---|
To: | Christoph Berg <myon(at)debian(dot)org> |
Cc: | "pgsql-pkg-debian(at)postgresql(dot)org" <pgsql-pkg-debian(at)postgresql(dot)org> |
Subject: | RE: Postgis raster2pgsql build with libx265-179 for jammy (22.04) but jammy does not ship this version |
Date: | 2023-04-14 08:56:59 |
Message-ID: | AM0PR01MB38431E6F4B7A5BA64EF5CFF0C8999@AM0PR01MB3843.eurprd01.prod.exchangelabs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-pkg-debian |
Hi Christoph,
Thank you for your response, your use of ldd triggered finding my way to my solution.
This was my thought process, in the end it was a custom build libheif (build for a custom imagemagick from before an OS upgrade, still on focal). Maybe this little dump of info is useful for someone who gets here via Google.
Alright I did some digging and this is the output for the ldd command for me. I also noticed that actually loading the postgis_raster extension gives the same error in postgresql 15.
$ ldd /usr/lib/postgresql/15/lib/postgis_raster-3.so | grep libx2
libx265.so.179 => not found
$ ldd /usr/bin/raster2pgsql | grep libx2
libx265.so.179 => not found
debsums postgresql-15-postgis-3 and debsums postgis give all OK's
$ md5sum /usr/bin/raster2pgsql
6e2debfe1e7cfc85db6073272081639b /usr/bin/raster2pgsql
$ md5sum /usr/lib/postgresql/15/lib/postgis_raster-3.so
8b5f432aea770b2d45a3f2e271e398b6 /usr/lib/postgresql/15/lib/postgis_raster-3.so
apt-cache show postgis
gives
MD5sum: 4ece3e079d25e11fb4d998012bbc9222
apt-cache show postgresql-15-postgis-3
gives
MD5sum: 95445f1cbf72629238663b744e69820c
And the live deb files:
$ curl -s http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/postgresql-15-postgis-3_3.3.2+dfsg-1.pgdg22.04+1_amd64.deb | md5sum
95445f1cbf72629238663b744e69820c -
$ curl -s http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/postgis_3.3.2+dfsg-1.pgdg22.04+1_amd64.deb | md5sum
4ece3e079d25e11fb4d998012bbc9222 -
So that seems to match. The files did come from the official deb http://apt.postgresql.org/pub/repos/apt/ jammy-pgdg main source.
So I went to dig further (lddtree was very helpful here), and I think I found the culprit in lib-heif installed by imei (imagemagick builder script) pre distro upgrade. So libgdal30.so loaded that one before the one build for jammy from the package repos.
Because all the hashes seemed to match, I didn't think to go look deeper until the very last moment. I'm sorry for coming to my conclusion so quickly before. lddtree and dpkg -S were really helpful in finding the actual culprit package (imei-libheif in my case). I did want to write a final message because maybe this helps someone who is searching in the future.
Kind regards,
---
Erwin de Haan
-----Original Message-----
From: Christoph Berg <myon(at)debian(dot)org>
Sent: donderdag 13 april 2023 20:39
To: Erwin de Haan <erwin(dot)de(dot)haan(at)calcasa(dot)nl>
Cc: pgsql-pkg-debian(at)postgresql(dot)org
Subject: Re: Postgis raster2pgsql build with libx265-179 for jammy (22.04) but jammy does not ship this version
[You don't often get email from myon(at)debian(dot)org(dot) Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]
Re: Erwin de Haan
> > raster2pgsql
> raster2pgsql: error while loading shared libraries: libx265.so.179:
> cannot open shared object file: No such file or directory
Hi Erwin,
works for me:
myon(at)jammy-amd64(dot)pgdgbuild:~ $ raster2pgsql
RELEASE: 3.3.2 GDAL_VERSION=34 (4975da8)
myon(at)jammy-amd64(dot)pgdgbuild:~ $ ldd /usr/bin/raster2pgsql | grep libx2
libx265.so.199 => /lib/x86_64-linux-gnu/libx265.so.199 (0x00007fb0b8631000)
Do you perhaps have a locally compiled postgis in /usr/local or the like?
Christoph
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Berg | 2023-04-14 17:57:35 | Re: Packaging request - pgvector |
Previous Message | Bradford Boyle | 2023-04-14 06:05:30 | Re: Packaging request - pgvector |