deegree3
deegree3 copied to clipboard
Update to PostgreSQL 10+ and PostGIS 3+
Currently deegree 3.4 supports PG v9.4-9.6 with PGIS v2.4-2.5. Required is the support of PG v10-13+ with PGIS 3+.
- [x] Upgrade to PG JDBC Driver 4.2.18+
- [x] Upgrade to PGIS Driver 2.5.0+
- [x] https://github.com/deegree/deegree3/blob/master/deegree-core/deegree-core-geometry/src/main/java/org/deegree/geometry/io/WKTReader.java#L82 requires refactoring since static method has been moved in v.2.5.0 to https://github.com/postgis/postgis-java/blob/master/postgis-jdbc-geometry/src/main/java/net/postgis/jdbc/geometry/GeometryBuilder.java#L22, maybe replace by JTS WKTReader
The support for PG 9.6 has ended with the last release version in November 2021 (see https://www.postgresql.org/support/versioning/). Latest Version of PG is 9.6.24, released November 11, 2021. An upgrade to at least PG 10.19 is required. Most recent release version of PG is v14.1. Preferred versions are PG 13 with PGIS 3.1 as provided by debian 11 (Bullseye).
Upgrade to PG JDBC Driver 4.2.18+ was done with PR #1277
Support for extended geometry types is documented #1321
Upgrade of PostGIS driver done with #1367.