<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <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 class="moz-cite-prefix">Op 14-5-2020 om 10:32 schreef Tom van
      Tilburg:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAP3PPDjvnwik=oY3M8ZHnUAEZV7+c7DH-iSeVEnFiU6aa_ckvw@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <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"
            moz-do-not-send="true">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"
            moz-do-not-send="true">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"
                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</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" moz-do-not-send="true">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"
                                moz-do-not-send="true">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" 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"
                                rel="noreferrer noreferrer"
                                target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
                              <a
                                href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
                                rel="noreferrer noreferrer noreferrer"
                                target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank" moz-do-not-send="true">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"
            moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
          <a
            href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
            rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
      </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>