[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Fwd: Re: Broken installs for PostGIS for Ubuntu 20.04LTS / Focal?
From: Marco Boeringa <marco () boeringa ! demon ! nl>
Date: 2020-05-15 13:01:35
Message-ID: 9ba0ff90-37f9-a8fd-fc66-4e3c99f755f0 () boeringa ! demon ! nl
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi Regina,
Thanks for explaining the reasons behind this. Yes, in hindsight putting
a note up about deprecation could have helped, although in my case the
function was part of some code I found on the Net and adjusted a little,
so I didn't really have a reason to lookup the 'ST_Accum' function in
the Help up to now, so would still have run into this.
Anyway, it is fixed now, and the code runs fine after switching to
'array_agg'.
Marco
Op 15-5-2020 om 14:39 schreef Regina Obe:
>
> Several reasons
>
> 1)Each function in itself is not that much, but compounded over many
> functions is a huge headache as if we change the newer version, we’d
> then have to remember to change the wrapper and in this case we’d have
> to keep track of what PostgreSQL is doing upstream since we have no
> control of array_agg. Aggregates are especially annoying since we had
> a state function tied behind this. So was really like 4 functions.
>
> 2)array_agg has been in PostgreSQL for a long long time. We assumed
> most users would be using that already instead of ST_Accum. There
> really was no reason to use ST_Accum past PostGIS 1.5 for any version
> of PostgreSQL. Granted we should have put a note on the page –
> deprecated so people new we’d be taking it out.
>
> 3)Wrappers are slower. In the case of ST_Accum(), I think it’s
> significantly slower
>
> 4)People are already complaining about too many functions in PostGIS.
> So keeping around old ones that we don’t want people using anyway just
> adds to the frustration of new users.
>
> *From:*postgis-users [mailto:postgis-users-bounces@lists.osgeo.org]
> *On Behalf Of *Marco Boeringa
> *Sent:* Friday, May 15, 2020 7:59 AM
> *To:* postgis-users@lists.osgeo.org
> *Subject:* Re: [postgis-users] Fwd: Re: Broken installs for PostGIS
> for Ubuntu 20.04LTS / Focal?
>
> 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:postgis-users-bounces@lists.osgeo.org] *On Behalf Of
> *Darafei "Kom?pa" Praliaskouski
> *Sent:* Friday, May 15, 2020 5:55 AM
> *To:* PostGIS Users Discussion <postgis-users@lists.osgeo.org>
> <mailto:postgis-users@lists.osgeo.org>
> *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
> <tom.van.tilburg@gmail.com <mailto:tom.van.tilburg@gmail.com>> 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
> <marco@boeringa.demon.nl <mailto:marco@boeringa.demon.nl>> 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
> <marco@boeringa.demon.nl
> <mailto:marco@boeringa.demon.nl>> 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 <marco@boeringa.demon.nl
> <mailto:marco@boeringa.demon.nl>> 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, <marco@boeringa.demon.nl
> <mailto:marco@boeringa.demon.nl>> 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,
> <marco@boeringa.demon.nl
> <mailto:marco@boeringa.demon.nl>>
> 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
> postgis-users@lists.osgeo.org
> <mailto:postgis-users@lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
>
> postgis-users mailing list
>
> postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> <mailto:postgis-users@lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
>
> postgis-users mailing list
>
> postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> <mailto:postgis-users@lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
>
> postgis-users mailing list
>
> postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
>
> postgis-users mailing list
>
> postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> <mailto:postgis-users@lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> <mailto:postgis-users@lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> --
>
> Darafei Praliaskouski
>
> Support me: http://patreon.com/komzpa
>
>
>
> _______________________________________________
>
> postgis-users mailing list
>
> postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
[Attachment #5 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Regina,</p>
<p>Thanks for explaining the reasons behind this. Yes, in hindsight
putting a note up about deprecation could have helped, although in
my case the function was part of some code I found on the Net and
adjusted a little, so I didn't really have a reason to lookup the
'ST_Accum' function in the Help up to now, so would still have run
into this.</p>
<p>Anyway, it is fixed now, and the code runs fine after switching
to 'array_agg'.<br>
</p>
<p>Marco<br>
</p>
<div class="moz-cite-prefix">Op 15-5-2020 om 14:39 schreef Regina
Obe:<br>
</div>
<blockquote type="cite"
cite="mid:002101d62ab5$e1e4e550$a5aeaff0$@pcorp.us">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1646355434;
mso-list-type:hybrid;
mso-list-template-ids:-774078802 67698705 67698713 67698715 67698703 67698713 \
67698715 67698703 67698713 67698715;} @list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Several
reasons<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> \
</o:p></span></p> <p class="MsoListParagraph"
style="text-indent:-.25in;mso-list:l0 level1 lfo1"><!--[if \
!supportLists]--><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><span
style="mso-list:Ignore">1)<span style="font:7.0pt
"Times New Roman""> \
</span></span></span><!--[endif]--><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Each
function in itself is not that much, but compounded over
many functions is a huge headache as if we change the newer
version, we’d then have to remember to change the wrapper
and in this case we’d have to keep track of what PostgreSQL
is doing upstream since we have no control of array_agg.
Aggregates are especially annoying since we had a state
function tied behind this. So was really like 4 \
functions.<o:p></o:p></span></p> <p class="MsoListParagraph"
style="text-indent:-.25in;mso-list:l0 level1 lfo1"><!--[if \
!supportLists]--><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><span
style="mso-list:Ignore">2)<span style="font:7.0pt
"Times New Roman""> \
</span></span></span><!--[endif]--><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">array_agg
has been in PostgreSQL for a long long time. We assumed
most users would be using that already instead of ST_Accum.
There really was no reason to use ST_Accum past PostGIS 1.5
for any version of PostgreSQL. Granted we should have put a
note on the page – deprecated so people new we’d be taking
it out.<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="text-indent:-.25in;mso-list:l0 level1 lfo1"><!--[if \
!supportLists]--><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><span
style="mso-list:Ignore">3)<span style="font:7.0pt
"Times New Roman""> \
</span></span></span><!--[endif]--><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Wrappers \
are slower. In the case of ST_Accum(), I think it’s
significantly slower<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="text-indent:-.25in;mso-list:l0 level1 lfo1"><!--[if \
!supportLists]--><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><span
style="mso-list:Ignore">4)<span style="font:7.0pt
"Times New Roman""> \
</span></span></span><!--[endif]--><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">People
are already complaining about too many functions in
PostGIS. So keeping around old ones that we don’t want
people using anyway just adds to the frustration of new
users.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> \
</o:p></span></p> <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> \
</o:p></span></p> <div style="border:none;border-left:solid blue 1.5pt;padding:0in
0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
postgis-users
[<a class="moz-txt-link-freetext" \
href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] \
<b>On Behalf Of </b>Marco Boeringa<br>
<b>Sent:</b> Friday, May 15, 2020 7:59 AM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" \
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br> \
<b>Subject:</b> Re: [postgis-users] Fwd: Re: Broken
installs for PostGIS for Ubuntu 20.04LTS / \
Focal?<o:p></o:p></span></p> </div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p>Hi Regina,<o:p></o:p></p>
<p>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.<o:p></o:p></p>
<p>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.<o:p></o:p></p>
<p>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.<o:p></o:p></p>
<p>Marc,<o:p></o:p></p>
<div>
<p class="MsoNormal">Op 15-5-2020 om 13:24 schreef Regina
Obe:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">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.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">So
it existed early in the life cycle of 3.0 but was later
removed</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Anyway
I’ve deleted ST_Length2D_Spheroid.html and
ST_Point_Inside_Circle.html which also seemed to have
the same issue</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> \
</span><o:p></o:p></p> <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> \
</span><o:p></o:p></p> <div style="border:none;border-left:solid blue
1.5pt;padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span
\
style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
postgis-users [<a
href="mailto:postgis-users-bounces@lists.osgeo.org"
\
moz-do-not-send="true">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On \
Behalf Of </b>Darafei "Kom?pa" Praliaskouski<br>
<b>Sent:</b> Friday, May 15, 2020 5:55 AM<br>
<b>To:</b> PostGIS Users Discussion <a
href="mailto:postgis-users@lists.osgeo.org"
\
moz-do-not-send="true"><postgis-users@lists.osgeo.org></a><br> <b>Subject:</b> \
Re: [postgis-users] Fwd: Re: Broken installs for PostGIS for Ubuntu 20.04LTS /
Focal?</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">It is mentioned in changelog and
removed from the docs. For some reason there is stray
page from older release.<o:p></o:p></p>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">On Fri, May 15, 2020 at 12:52 PM
Tom van Tilburg <<a
href="mailto:tom.van.tilburg@gmail.com"
moz-do-not-send="true">tom.van.tilburg@gmail.com</a>>
wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC
1.0pt;padding:0in 0in 0in
6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal">It's the first thing I ran
into as well after upgrading .<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">But it hasn't been mentioned
in the docs? Whoops... time for an issue...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Tom<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">On Fri, May 15, 2020 at 10:56
AM Marco Boeringa <<a
href="mailto:marco@boeringa.demon.nl"
target="_blank" \
moz-do-not-send="true">marco@boeringa.demon.nl</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid
#CCCCCC 1.0pt;padding:0in 0in 0in
6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<p>Tom,<o:p></o:p></p>
<p>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:<o:p></o:p></p>
<p><a
href="https://trac.osgeo.org/postgis/ticket/4356"
target="_blank" \
moz-do-not-send="true">https://trac.osgeo.org/postgis/ticket/4356</a><o:p></o:p></p> \
<p><a
href="https://trac.osgeo.org/postgis/changeset/17397"
target="_blank" \
moz-do-not-send="true">https://trac.osgeo.org/postgis/changeset/17397</a><o:p></o:p></p>
<p>Both mention replacing 'ST_Accum' with
'array_agg'.<o:p></o:p></p>
<p>Marco<o:p></o:p></p>
<div>
<p class="MsoNormal">Op 15-5-2020 om 10:38
schreef Marco Boeringa:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p>Tom,<o:p></o:p></p>
<p>One more question:<o:p></o:p></p>
<p>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).<o:p></o:p></p>
<p>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:<o:p></o:p></p>
<p><a
href="https://postgis.net/docs/ST_Accum.html"
target="_blank" \
moz-do-not-send="true">https://postgis.net/docs/ST_Accum.html</a><o:p></o:p></p> \
<p>Marco<o:p></o:p></p> <div>
<p class="MsoNormal">Op 14-5-2020 om 11:42
schreef Tom van Tilburg:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal">Whatever lives in
/usr/local/lib was my manual build so
I had to delete that manually.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I did `sudo rm
/usr/local/lib/libgeos*` (same for
proj and sfcgal)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">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.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Best,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Tom<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">On Thu, May 14,
2020 at 10:45 AM Marco Boeringa <<a
href="mailto:marco@boeringa.demon.nl" target="_blank"
\
moz-do-not-send="true">marco@boeringa.demon.nl</a>> wrote:<o:p></o:p></p>
</div>
<blockquote
style="border:none;border-left:solid
#CCCCCC 1.0pt;padding:0in 0in 0in
6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<p>Hi Tom,<o:p></o:p></p>
<p>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.<o:p></o:p></p>
<p>Marco<o:p></o:p></p>
<div>
<p class="MsoNormal">Op 14-5-2020 om
10:32 schreef Tom van Tilburg:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal">I think I
solved it.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">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).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">This issue
put me on the right track:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a
\
href="https://github.com/OSGeo/gdal/issues/2214" target="_blank"
\
moz-do-not-send="true">https://github.com/OSGeo/gdal/issues/2214</a><o:p></o:p></p> \
</div> <div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">T.<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">On Wed, May
13, 2020 at 3:15 PM Marco
Boeringa <<a
href="mailto:marco@boeringa.demon.nl"
target="_blank"
\
moz-do-not-send="true">marco@boeringa.demon.nl</a>> wrote:<o:p></o:p></p>
</div>
<blockquote
style="border:none;border-left:solid
#CCCCCC 1.0pt;padding:0in 0in
0in
6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<p>Thanks Tom,<o:p></o:p></p>
<p>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.<o:p></o:p></p>
<p>SQL Error [XX000]: ERROR:
could not load library
"/usr/lib/postgresql/11/lib/<a
href="http://rtpostgis-2.5.so" target="_blank" \
moz-do-not-send="true">rtpostgis-2.5.so</a>": /usr/lib/libgdal.so.26:
undefined symbol:
GEOSMakeValid_r<br>
Where: SQL statement
"SELECT
public.postgis_gdal_version()"<br>
PL/pgSQL function
postgis_full_version() line
34 at SQL statement<o:p></o:p></p>
<p>Marco<o:p></o:p></p>
<div>
<p class="MsoNormal"
style="margin-bottom:12.0pt"> \
<o:p></o:p></p> <div>
<div>
<p class="MsoNormal">Sorry
for the short answer,
am on the way
currently. Will try to
do a decent report
tonight.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Error
is roughly the same
but comes from
libgdal26 in my case
when doing apt install
qgis after an upgrade
to 20.04.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"
style="margin-bottom:12.0pt">best,
Tom<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">On
Wed, 13 May 2020,
14:48 Marco
Boeringa, <<a
\
href="mailto:marco@boeringa.demon.nl" target="_blank"
moz-do-not-send="true">marco@boeringa.demon.nl</a>> wrote:<o:p></o:p></p>
</div>
<blockquote
\
style="border:none;border-left:solid #CCCCCC
1.0pt;padding:0in
0in 0in
6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<p>Thanks for the
response Tom,
but could you be
a bit more
specific? <o:p></o:p></p>
<p>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?<o:p></o:p></p>
<p>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.<o:p></o:p></p>
<div>
<p
\
class="MsoNormal">Marco<o:p></o:p></p> </div>
<div>
<p
class="MsoNormal"> \
<o:p></o:p></p> </div>
<div>
<p
class="MsoNormal">Op
13-5-2020 om
14:40 schreef
Tom van
Tilburg:<o:p></o:p></p>
</div>
<blockquote
\
style="margin-top:5.0pt;margin-bottom:5.0pt"> <div>
<p
class="MsoNormal">Same
problem with
qgis<o:p></o:p></p>
</div>
<p
class="MsoNormal"> \
<o:p></o:p></p> <div>
<div>
<p
class="MsoNormal">On
Wed, 13 May
2020, 11:14
Marco
Boeringa, <<a
href="mailto:marco@boeringa.demon.nl" target="_blank"
\
moz-do-not-send="true">marco@boeringa.demon.nl</a>>
wrote:<o:p></o:p></p>
</div>
<blockquote
\
style="border:none;border-left:solid #CCCCCC
1.0pt;padding:0in
0in 0in
6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<p
class="MsoNormal">Hi
all,<br>
<br>
Is there
someone who
can confirm
they have been
able to
install
PostGIS <br>
3.0.1 via the
official APT
repository?:<br>
<br>
<a
\
href="https://wiki.postgresql.org/wiki/Apt" target="_blank" \
moz-do-not-send="true">https://wiki.postgresql.org/wiki/Apt</a><br> <br>
After using
the Synaptics
Package
Manager to
install the
three packages
<br>
involved <br>
("postgresql-12-postgis-3"/"postgresql-12-postgis-3-dbgsym"/"postgresql-12-postgis-3-scripts"),
<br>
and
subsequently
trying to
create the
PostGIS
extension in
pgAdmin4, I <br>
get the
following
error:<br>
<br>
ERROR: could
not load
library
\
"/usr/lib/postgresql/12/lib/postgis-3.so": <br>
/usr/lib/postgresql/12/lib/postgis-3.so: undefined symbol: GEOSMakeValid<br>
<br>
I have been
trying
different
things to fix
this for past
two days <br>
including
re-install,
but to no
avail. I have
also attempted
to include <br>
the UbuntuGIS
repository as
a potential
alternative
resource of
PostGIS <br>
packages, but
discovered the
UbuntuGIS
repository is
lagging behind
and <br>
doesn't yet
have packages
for 20.04LTS.<br>
<br>
Marco<br>
<br>
_______________________________________________<br>
postgis-users
mailing list<br>
<a
\
href="mailto:postgis-users@lists.osgeo.org" target="_blank" \
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br> <a
\
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" \
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</blockquote>
</div>
<p
class="MsoNormal"> \
<o:p></o:p></p>
\
<pre>_______________________________________________<o:p></o:p></pre>
<pre>postgis-users mailing \
list<o:p></o:p></pre> <pre><a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><o:p></o:p></pre>
<pre><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" \
target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></pre>
</blockquote>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
<p \
class="MsoNormal">_______________________________________________<br> postgis-users \
mailing list<br> <a
\
href="mailto:postgis-users@lists.osgeo.org" target="_blank"
\
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br> <a
\
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank"
\
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
\
<pre>_______________________________________________<o:p></o:p></pre>
<pre>postgis-users mailing list<o:p></o:p></pre>
<pre><a \
href="mailto:postgis-users@lists.osgeo.org" target="_blank" \
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><o:p></o:p></pre> <pre><a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" \
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></pre>
</blockquote>
</div>
<p \
class="MsoNormal">_______________________________________________<br> postgis-users \
mailing list<br> <a
href="mailto:postgis-users@lists.osgeo.org"
target="_blank"
\
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br> <a
\
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank"
\
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
\
<pre>_______________________________________________<o:p></o:p></pre>
<pre>postgis-users mailing list<o:p></o:p></pre>
<pre><a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><o:p></o:p></pre>
<pre><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" \
target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
\
<pre>_______________________________________________<o:p></o:p></pre> \
<pre>postgis-users mailing list<o:p></o:p></pre> <pre><a \
href="mailto:postgis-users@lists.osgeo.org" target="_blank" \
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><o:p></o:p></pre> <pre><a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" \
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></pre>
</blockquote>
</div>
<p \
class="MsoNormal">_______________________________________________<br> postgis-users \
mailing list<br> <a href="mailto:postgis-users@lists.osgeo.org"
target="_blank" \
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br> <a
\
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
target="_blank" \
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</blockquote>
</div>
<p \
class="MsoNormal">_______________________________________________<br> postgis-users \
mailing list<br> <a href="mailto:postgis-users@lists.osgeo.org"
target="_blank" \
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br> <a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
target="_blank" \
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Darafei Praliaskouski<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Support me: <a
href="http://patreon.com/komzpa"
target="_blank" \
moz-do-not-send="true">http://patreon.com/komzpa</a><o:p></o:p></p> </div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>postgis-users mailing list<o:p></o:p></pre>
<pre><a href="mailto:postgis-users@lists.osgeo.org" \
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><o:p></o:p></pre> <pre><a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" \
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></pre>
</blockquote>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" \
wrap="">_______________________________________________ postgis-users mailing list
<a class="moz-txt-link-abbreviated" \
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a> <a \
class="moz-txt-link-freetext" \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
</body>
</html>
[Attachment #6 (text/plain)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic