This article was originally published on May 18, 2021
WHAT’S NEW
This update is notifying you of a new software release of EDB PostGIS. EDB PostGIS (or PostGIS) is a PostgreSQL extension that allows you to store Geographic Information Systems (GIS) objects in an EDB Postgres Advanced Server (EPAS) database. It includes functions for analyzing and processing GIS objects, and support for GiST-based R-Tree spatial indexes.
Highlights of this release
- Merged with upstream, which includes 18 bug fixes, 7 new features and 41 enhancements (as described in the Upstream release notes - Appendix A.1 to A.5). New features and enhancements include:
- This version exposes the new features of GEOS 3.9 as well as numerous core performance enhancements for spatial joins, large object access, text format output, and more.
- Performance is a key feature of this release, with improvements to spatial joins, text outputs, large object reads, vector tile output, and a host of smaller tweaks.
- The k-means clustering code has been enhanced to support weighting and higher dimensional clusters.
- Geometry generators to create hexagonal and square tilings have been added, for simpler in-the-database summarization queries.
- Finally, PostGIS exposes the latest enhancements in the GEOS geometry library 3.9 version. The new overlay engine (aka “OverlayNG”) provides more robust handling of difficult input geometries, using a set of new noding strategies to process geometry. For the end user this should mean no more "topology exceptions'' when using the union, difference, intersection, or symmetric difference functions. PostGIS also exposes the new fixed precision overlay capability via an additional grid-size parameter on ST_Intersection and the other overlay functions.
- Released for all supported platforms and all supported EPAS releases, which allows for easy upgrade to PostGIS 3.1 and after that to a newer EPAS release.
Note that the sfcgal functionality is only available for RHEL/CentOS 7 on x86_64, and Debian 9/10. The sfcgal functionality is not available on Ubuntu 18, Ubuntu 20, SLES 12, RHEL/CentOS 7 on IBM Power8/9 (LE), and Windows.
Defects corrected in this update
The release contains 18 bug fixes as described in the Upstream release notes (Appendix A.1 to A.5), including:
- Stability:
- Multiple issues causing crashes and segfaults
- Always initialize internal cache
- Memory related bugs
- Non default schema fix
- Functional:
- Fixing unstable results
- Round values the same
- Fix calculations with identical verticals
- Bug on positive value request
- VSICURL to work as documented
Breaking changes
With PostGIS 3.1 the following deprecated functions have been removed:
- ST_Count(tablename,...),
- ST_ApproxCount(tablename, ...)
- ST_SummaryStats(tablename, ..),
- ST_Histogram(tablename, ...),
- ST_ApproxHistogram(tablename, ...),
- ST_Quantile(tablename, ...),
- ST_ApproxQuantile(tablename, ...)
The script postgis_proc_set_search_path.pl is no longer part of the distribution
The signature is changed for these methods, and they now required one more parameter (margin):
- ST_TileEnvelope
- ST_Force3D
- ST_Force3DZ
- ST_Force3DM
- ST_Force4D
TELL ME MORE
For more details, please review the EDB PostGIS documentation:
https://www.enterprisedb.com/docs/postgis/latest/
IS THIS FOR ME?
This announcement is for EDB customers who have an Enterprise Subscription and are either currently using or are interested in deploying PostGIS on EDB Postgres Advanced Server.
HOW TO GET THE SOFTWARE
EDB PostGIS is packaged and delivered as a series of interactive installers for Windows (x86-64), available via StackBuilder Plus and on the EnterpriseDB website. Visit:
https://www.enterprisedb.com/advanced-downloads
This update is also available as native packages in the form of RPMs and DEBs for Linux, please visit:
https://repos.enterprisedb.com/
To request the credentials required to access EnterpriseDB repositories, please visit https://www.enterprisedb.com/repository-access-request
Documentation is provided on the EnterpriseDB website.
Visit: https://www.enterprisedb.com/docs/postgis/latest/
TROUBLESHOOTING
If you experience any problems around the installation, migration, upgrade or general use of your EDB software please contact our Technical Support teams. We can be reached at https://support.enterprisedb.com, and we’re also available 24 x 7 via email or phone at the details below:
Email: support@enterprisedb.com
Phone: US: +1-732-331-1320 or 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: +91-20-66449612