<div dir="ltr"><div>It's the first thing I ran into as well after upgrading .<br></div><div>But it hasn't been mentioned in the docs? Whoops... time for an issue...<br></div><div><br></div><div>Tom<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, May 15, 2020 at 10:56 AM Marco Boeringa <<a href="mailto:marco@boeringa.demon.nl">marco@boeringa.demon.nl</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
  
    
  
  <div>
    <p>Tom,</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:<br>
    </p>
    <p><a href="https://trac.osgeo.org/postgis/ticket/4356" target="_blank">https://trac.osgeo.org/postgis/ticket/4356</a></p>
    <p><a href="https://trac.osgeo.org/postgis/changeset/17397" target="_blank">https://trac.osgeo.org/postgis/changeset/17397</a></p>
    <p>Both mention replacing 'ST_Accum' with 'array_agg'.</p>
    <p>Marco<br>
    </p>
    <div>Op 15-5-2020 om 10:38 schreef Marco
      Boeringa:<br>
    </div>
    <blockquote type="cite">
      
      <p>Tom,</p>
      <p>One more question:</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).</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:</p>
      <p><a href="https://postgis.net/docs/ST_Accum.html" target="_blank">https://postgis.net/docs/ST_Accum.html</a></p>
      <p>Marco<br>
      </p>
      <div>Op 14-5-2020 om 11:42 schreef Tom van
        Tilburg:<br>
      </div>
      <blockquote type="cite">
        
        <div dir="ltr">
          <div>Whatever lives in /usr/local/lib was my manual build so I
            had to delete that manually.<br>
          </div>
          <div>I did  `sudo rm /usr/local/lib/libgeos*` (same for proj
            and sfcgal)</div>
          <div>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.</div>
          <div><br>
          </div>
          <div>Best,</div>
          <div> Tom<br>
          </div>
        </div>
        <br>
        <div class="gmail_quote">
          <div dir="ltr" class="gmail_attr">On Thu, May 14, 2020 at
            10:45 AM Marco Boeringa <<a href="mailto:marco@boeringa.demon.nl" target="_blank">marco@boeringa.demon.nl</a>>
            wrote:<br>
          </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div>
              <p>Hi Tom,</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.</p>
              <p>Marco<br>
              </p>
              <div>Op 14-5-2020 om 10:32 schreef Tom van Tilburg:<br>
              </div>
              <blockquote type="cite">
                <div dir="ltr">
                  <div>I think I solved it.</div>
                  <div>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).<br>
                  </div>
                  <div><br>
                  </div>
                  <div>This issue put me on the right track:</div>
                  <div><a href="https://github.com/OSGeo/gdal/issues/2214" target="_blank">https://github.com/OSGeo/gdal/issues/2214</a></div>
                  <div><br>
                  </div>
                  <div>T.<br>
                  </div>
                </div>
                <br>
                <div class="gmail_quote">
                  <div dir="ltr" class="gmail_attr">On Wed, May 13, 2020
                    at 3:15 PM Marco Boeringa <<a href="mailto:marco@boeringa.demon.nl" target="_blank">marco@boeringa.demon.nl</a>>
                    wrote:<br>
                  </div>
                  <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
                    <div>
                      <p>Thanks Tom,</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.<br>
                      </p>
                      <p>SQL Error [XX000]: ERROR: could not load
                        library "/usr/lib/postgresql/11/lib/<a href="http://rtpostgis-2.5.so" target="_blank">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</p>
                      <p>Marco<br>
                      </p>
                      <div><br>
                        <br>
                        <div dir="auto">
                          <div>Sorry for the short answer, am on the way
                            currently. Will try to do a decent report
                            tonight.</div>
                          <div dir="auto"><br>
                          </div>
                          <div dir="auto">Error is roughly the same but
                            comes from libgdal26 in my case when doing
                            apt install qgis after an upgrade to 20.04.</div>
                          <div dir="auto"><br>
                          </div>
                          <div dir="auto">best, Tom<br>
                            <br>
                            <div class="gmail_quote" dir="auto">
                              <div dir="ltr" class="gmail_attr">On Wed,
                                13 May 2020, 14:48 Marco Boeringa, <<a href="mailto:marco@boeringa.demon.nl" target="_blank">marco@boeringa.demon.nl</a>>
                                wrote:<br>
                              </div>
                              <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
                                <div>
                                  <p>Thanks for the response Tom, but
                                    could you be a bit more specific? <br>
                                  </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?</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.<br>
                                  </p>
                                  <div>Marco</div>
                                  <div><br>
                                  </div>
                                  <div>Op 13-5-2020 om 14:40 schreef Tom
                                    van Tilburg:<br>
                                  </div>
                                  <blockquote type="cite">
                                    <div dir="auto">Same problem with
                                      qgis</div>
                                    <br>
                                    <div class="gmail_quote">
                                      <div dir="ltr" class="gmail_attr">On
                                        Wed, 13 May 2020, 11:14 Marco
                                        Boeringa, <<a href="mailto:marco@boeringa.demon.nl" rel="noreferrer" target="_blank">marco@boeringa.demon.nl</a>>
                                        wrote:<br>
                                      </div>
                                      <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">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" rel="noreferrer noreferrer
                                          noreferrer" target="_blank">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" rel="noreferrer noreferrer" target="_blank">postgis-users@lists.osgeo.org</a><br>
                                        <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer noreferrer
                                          noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
                                    </div>
                                    <br>
                                    <fieldset></fieldset>
                                    <pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" rel="noreferrer" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
                                  </blockquote>
                                </div>
                              </blockquote>
                            </div>
                          </div>
                        </div>
                      </div>
                    </div>
                    _______________________________________________<br>
                    postgis-users mailing list<br>
                    <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
                    <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
                </div>
                <br>
                <fieldset></fieldset>
                <pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
              </blockquote>
            </div>
            _______________________________________________<br>
            postgis-users mailing list<br>
            <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
            <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
        </div>
        <br>
        <fieldset></fieldset>
        <pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
      </blockquote>
      <br>
      <fieldset></fieldset>
      <pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
    </blockquote>
  </div>

_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div>