This article was originally published on June 24, 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.
EDB PostGIS packages are available for PostgreSQL and EDB Postgres Advanced.
Highlights of this release
This release contains a merge with upstream, which includes the following bug fixes:
|
Highlights |
Type |
|
Improved handling of more complex compound coordinate systems |
Bugfix |
|
The SRID in TopoGeometry is fixed for empty geometry objects |
Bugfix |
|
Improved message when no zip code is provided for postgis_tiger_geocoder |
Bugfix |
|
Axis flips are now done for a CRS when "Lat" is set as the first column. In other cases EPSG database order is used. |
Bugfix |
|
Support recent Proj versions that have removed pj_get_release |
Bugfix |
|
The tolerance is now adjusted to improve geodetic calculations |
Bugfix |
|
Fix on improper conversion of negative geographic azimuth to positive |
Bugfix |
|
Allow DBSCAN cluster to form when recordset length equal to minPoints |
Bugfix |
|
Ensure bounding boxes are refreshed after coordinate transforms |
Bugfix |
|
Fix raster issues related to PostgreSQL 14 tablefunc changes |
Bugfix |
|
Update to support Tiger 2020 |
Bugfix |
|
Change Proj cache lifetime to last as long as connection |
Bugfix |
For more information, please refer to the Upstream release notes.
Notes
- 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.
- With PostGIS 3.1.2, the return type of the raster functions have changed, which requires dropping and creating the extension as part of the upgrade process.
- When upgrading from 2.5.4 (or lower) to 3.1.2, you need to upgrade to 3.1.1 first as an intermediate step before upgrading to 3.1.2.
- When the PostGIS data has a dependency on the raster functions, upgrading to PostGIS 3.1.2 requires dumping and reloading the data.
Please refer to the documentation for information about the complete upgrade process.
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 or 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 EDB repositories, please visit https://www.enterprisedb.com/repository-access-request
Documentation is provided on the EDB 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