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:[email protected]]
*On Behalf Of *Karsten Tebling
*Sent:* Tuesday, December 20, 2022 6:07 AM
*To:* [email protected]
*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
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
