deegree3 icon indicating copy to clipboard operation
deegree3 copied to clipboard

Update to PostgreSQL 10+ and PostGIS 3+

Open tfr42 opened this issue 4 years ago • 4 comments

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+.

tfr42 avatar Feb 03 '21 16:02 tfr42

  • [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

tfr42 avatar Feb 04 '21 19:02 tfr42

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).

tfr42 avatar Jan 30 '22 18:01 tfr42

Upgrade to PG JDBC Driver 4.2.18+ was done with PR #1277

tfr42 avatar Feb 21 '22 13:02 tfr42

Support for extended geometry types is documented #1321

tfr42 avatar May 12 '22 10:05 tfr42

Upgrade of PostGIS driver done with #1367.

tfr42 avatar Sep 17 '22 11:09 tfr42