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