[postgis-users] error: Directed line merging requires GEOS-3.11 or higher

[Karsten Tebling]

Hello Regina,

thanks to your information I could find a workaround. I ended up 
removing the postgresql and ubuntugis-unstable repositories along with 
the installed software and installed docker to use the alpine-based 
docker files (https://registry.hub.docker.com/r/postgis/postgis/). The 
restore was successful and everything seems to be working so far.

Thanks for the help!

Am 20.12.2022 um 18:02 schrieb Regina Obe:
>
> If you have ubuntugis-unstableinstalled too, it’s quite possible that 
> your GEOS is coming from ubuntugis unstable
>
> and your postgis is coming from apt.postgresql.org. Even worse as I 
> recall, I think ubuntugis relegates compiling of postgis upstream 
> (main repo), so you might still end up with a PostGIS compiled with a 
> lower version.
>
> apt.postgresql.org builds against whatever the base repo is of 
> Ubuntu/Debian etc.  Last I checked, all stable releases (at least for 
> Ubuntu) I could get put you at GEOS 3.10.  So I suspect your Mint 
> postgis was at best compiled with GEOS 3.10.
>
> Unfortunately the GEOS is checked at compile time for enabling 
> features, not runtime, but our full version exposes
>
> the runtime that is being used, which for most cases is useful, except 
> for the case where new features are disabled.
>
> Sandro and Paul, is there any way we can expose the compiled version 
> of GEOS and Proj?
>
> This isn’t the first time someone has been confused by this issue and 
> it’s been even worse with Proj (around those times when the proj.db 
> changed)
>
> I think I asked before but I forget what you two answered.
>
> Thanks,
>
> Regina
>
> *From:*postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] 
> *On Behalf Of *Karsten Tebling
> *Sent:* Tuesday, December 20, 2022 6:07 AM
> *To:* postgis-users at lists.osgeo.org
> *Subject:* [postgis-users] error: Directed line merging requires 
> GEOS-3.11 or higher
>
> Hello,
>
> I'm trying to restore a backup from a windows installation to a new 
> linux mint 21 installation but it always fails with "error: Directed 
> line merging requires GEOS-3.11 or higher". According to the 
> postgis_full_version both installations should support geos 3.11, but 
> I do get the error anyway. I'm using pgadmin4-desktop (installed via 
> apt https://www.pgadmin.org/download/pgadmin-4-apt/) to execute the 
> queries.
>
> postgis_full_version:
>
>   * windows: POSTGIS="3.3.2 3.3.2" [EXTENSION] PGSQL="140"
>     GEOS="3.11.1-CAPI-1.17.1" PROJ="7.2.1" LIBXML="2.9.9"
>     LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)"
>   * linux mint: POSTGIS="3.3.2 4975da8" [EXTENSION] PGSQL="150"
>     GEOS="3.11.1-CAPI-1.17.1" PROJ="8.2.1" LIBXML="2.9.13"
>     LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"
>
> The linux mint is a fresh installation, I installed postgresql and 
> postgis via PostgreSQL Apt Repository 
> (https://www.postgresql.org/download/linux/ubuntu/), using the command:
>
>   * sudo apt install postgresql-15 postgis postgresql-15-postgis-3
>
> Another ppa I have in use is ubuntugis-unstable, it also includes 
> postgis - could this be a reason for the problem?
>
> Help would be greatly appreciated.
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20221221/fdd82882/attachment.htm>