Hi Regina,
Yes, I found this via Google. After the update, it now indeed errors out
on a 404. ST_Collect also no longer mentions it, so that seems fine now.
I do slightly wonder by the way why ST_Accum wasn't simple
re-implemented as a wrapper around 'array_agg'. While I appreciate
breaking changes may be necessary and are to be expected for a major
version update like 2.x to 3.x, in this particular case, where wrapping
the function would have been an easy solution, could have avoided
breaking existing code with minimal effort and maintenance overhead.
Anyway, the required code changes are luckily minimal as well, just
replace 'ST_Accum()' with 'array_agg()' as per the OSGeo tickets I saw,
so that is not a big deal. I have now implemented this in my own code.
Marc,
Op 15-5-2020 om 13:24 schreef Regina Obe:
Yes stray doc. Did you find this via google. Looks like that page
last got updated 4/17/2019. It’s the nature of how we build the docs
that the updates overwrite existing for a particular Minor version,
but don’t delete.
So it existed early in the life cycle of 3.0 but was later removed
Anyway I’ve deleted ST_Length2D_Spheroid.html and
ST_Point_Inside_Circle.html which also seemed to have the same issue
*From:*postgis-users [mailto:[email protected]]
*On Behalf Of *Darafei "Kom?pa" Praliaskouski
*Sent:* Friday, May 15, 2020 5:55 AM
*To:* PostGIS Users Discussion <[email protected]>
*Subject:* Re: [postgis-users] Fwd: Re: Broken installs for PostGIS
for Ubuntu 20.04LTS / Focal?
It is mentioned in changelog and removed from the docs. For
some reason there is stray page from older release.
On Fri, May 15, 2020 at 12:52 PM Tom van Tilburg
<[email protected] <mailto:[email protected]>> wrote:
It's the first thing I ran into as well after upgrading .
But it hasn't been mentioned in the docs? Whoops... time for an
issue...
Tom
On Fri, May 15, 2020 at 10:56 AM Marco Boeringa
<[email protected] <mailto:[email protected]>> wrote:
Tom,
It now appears the PostGIS team indeed removed 'ST_Accum', but
forgot to update the online PostGIS Help. I see two OSGEO
tickets related to this:
https://trac.osgeo.org/postgis/ticket/4356
https://trac.osgeo.org/postgis/changeset/17397
Both mention replacing 'ST_Accum' with 'array_agg'.
Marco
Op 15-5-2020 om 10:38 schreef Marco Boeringa:
Tom,
One more question:
After successfully installing the PostGIS 3.0.1 extension
using CREATE EXTENSION in pgAdmin4 on PostgreSQL 12.3 on
Ubuntu 20.04 Focal, I now ran into an issue where it
appears the 'ST_Accum' function is missing in my PostGIS
install. My code calls this, and it failed. I then had a
look at the function list in pgAdmin, and indeed
'ST_Accum' is not listed. I do see loads of other PostGIS
functions, just 'ST_Accum' seems missing (although I
cannot garantuee there are a few more missing functions,
but the list seems pretty comprehensive from a quick look,
and the CREATE EXTENSION call went without a hitch).
Can you confirm you see 'ST_Accum' in your PostGIS 3.0.1
function list if you look in pgAdmin? The PostGIS Help
does not mention some deprecation of this function:
https://postgis.net/docs/ST_Accum.html
Marco
Op 14-5-2020 om 11:42 schreef Tom van Tilburg:
Whatever lives in /usr/local/lib was my manual build
so I had to delete that manually.
I did `sudo rm /usr/local/lib/libgeos*` (same for
proj and sfcgal)
On top of that I purged all old package configurations
`sudo apt purge <packagename>` just to be sure but I
don't think it is needed.
Best,
Tom
On Thu, May 14, 2020 at 10:45 AM Marco Boeringa
<[email protected]
<mailto:[email protected]>> wrote:
Hi Tom,
Thanks for the tip, but what did you do to remove
the old install? Did you rely on Apt or Synaptic
to remove the old libgeos version, or did you
manually clean up folders? I had two versions of
libgeos as well (3.7 and 3.8) if I remember well
(need to start up the VM again to check), and
removed the older one through Synaptic just
leaving the 3.8 version, but that wasn't enough to
solve my particular issues.
Marco
Op 14-5-2020 om 10:32 schreef Tom van Tilburg:
I think I solved it.
The issue lies with gdal, not postgis (test by
running `gdalinfo`), and it turns out there
was an old install of libgeos (3.7) in my
/us/local/lib. After simply removing all
related files in /usr/local/lib gdal (and
postgis and qgis) stopped complaining (I had
to remove old installs of geos, proj and
sfcgal for that).
This issue put me on the right track:
https://github.com/OSGeo/gdal/issues/2214
T.
On Wed, May 13, 2020 at 3:15 PM Marco Boeringa
<[email protected]
<mailto:[email protected]>> wrote:
Thanks Tom,
I have seen a similar error related to the
"libgdal26" library, but that was after
other trials to get something running on
Ubuntu 20.04 Focal, where I successfully
installed PostGIS 2.5.4, but then
encountered issues when my code called the
"postgis_full_version()" function and
errored out with the error message below
related to the "libgdal.so.26" library.
However, as said, this was with PostGIS
2.5.4, not with the PostGIS 3.0.1 I
actually want to install at this moment
and that gave the other error related to
the "postgis-3.so" library.
SQL Error [XX000]: ERROR: could not load
library
"/usr/lib/postgresql/11/lib/rtpostgis-2.5.so
<http://rtpostgis-2.5.so>":
/usr/lib/libgdal.so.26: undefined symbol:
GEOSMakeValid_r
Where: SQL statement "SELECT
public.postgis_gdal_version()"
PL/pgSQL function postgis_full_version()
line 34 at SQL statement
Marco
Sorry for the short answer, am on the way
currently. Will try to do a decent report
tonight.
Error is roughly the same but comes from
libgdal26 in my case when doing apt
install qgis after an upgrade to 20.04.
best, Tom
On Wed, 13 May 2020, 14:48 Marco Boeringa,
<[email protected]
<mailto:[email protected]>> wrote:
Thanks for the response Tom, but could
you be a bit more specific?
What do you mean with "Same problem
with qgis"? Do you mean you've also
encountered a "undefined symbol:
GEOSMakeValid" error related to the
"postgis-3.so" library when trying to
use some tool in QGIS?
I have installed PostgreSQL 12 and
PostGIS 3.0.1 via Synaptic on Ubuntu
20.04 (Focal) and use CREATE EXTENSION
(via pgAdmin4), when I encounter the
error.
Marco
Op 13-5-2020 om 14:40 schreef Tom van
Tilburg:
Same problem with qgis
On Wed, 13 May 2020, 11:14 Marco
Boeringa, <[email protected]
<mailto:[email protected]>>
wrote:
Hi all,
Is there someone who can
confirm they have been able to
install PostGIS
3.0.1 via the official APT
repository?:
https://wiki.postgresql.org/wiki/Apt
After using the Synaptics
Package Manager to install the
three packages
involved
("postgresql-12-postgis-3"/"postgresql-12-postgis-3-dbgsym"/"postgresql-12-postgis-3-scripts"),
and subsequently trying to
create the PostGIS extension
in pgAdmin4, I
get the following error:
ERROR: could not load library
"/usr/lib/postgresql/12/lib/postgis-3.so":
/usr/lib/postgresql/12/lib/postgis-3.so:
undefined symbol: GEOSMakeValid
I have been trying different
things to fix this for past
two days
including re-install, but to
no avail. I have also
attempted to include
the UbuntuGIS repository as a
potential alternative resource
of PostGIS
packages, but discovered the
UbuntuGIS repository is
lagging behind and
doesn't yet have packages for
20.04LTS.
Marco
_______________________________________________
postgis-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected] <mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
--
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
_______________________________________________
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
