[postgis-users] Does ArcGIS 2.7 Pro work with PostgreSQL 13 / PostGIS 3.1

Mon May 24 02:02:58 PDT 2021

I haven't used ArcGIS etc for many years, but the old answer was yes but you needed an Enterprise GeDatabase (ArcSDE) license which works with any of the supported "storage formats".

Get BlueMail for Android

On 24 May 2021, 18:55, at 18:55, Alexandre Neto <senhor.neto at gmail.com> wrote:
><div dir="auto">I have this question for years... Never got a straight
>answer.<div dir="auto"><br></div><div dir="auto">Is it possible to edit
>PostGIS tables/geometries using ArcGIS? (Without converting into the
>proprietary geometry type)</div><div dir="auto"><br></div><div
>dir="auto">If so, what license level is needed?</div><div
>dir="auto"><br></div><div dir="auto">Thanks,</div><div
>dir="auto"><br></div><div dir="auto">Alexandre Neto</div></div><br><div
>class="gmail_quote"><div dir="ltr" class="gmail_attr">A sábado,
>22/05/2021, 12:29, Marco Boeringa <<a
>href="mailto:marco at boeringa.demon.nl">marco at boeringa.demon.nl</a>>
>escreveu:<br></div><blockquote class="gmail_quote" style="margin:0 0 0
>.8ex;border-left:1px #ccc solid;padding-left:1ex">
>  
>    
>  
>  <div>
>    <p>I doubt this browsing issue has anything to do with
>'random_page_cost'... Why on earth would it? This is a
>PostgreSQL
>      setting, to which the ESRI software is essentially completely
>      oblivious. <br>
>    </p>
>    <p>The ESRI software just sits on top of this PostgreSQL
>  infrastructure, it essentially doesn't do anything different than
>     QGIS does, just watch the SQL statements coming in in PgAdmin.<br>
>    </p>
>   <p>I have been running ArcMap and latest ArcGIS Pro versions against
> up to PostgreSQL 13 / PostGIS 3.1 mostly fine using ArcGIS "Query
>  Layers", including browsing data from the catalogs in ArcMap and
>      Pro, with a postgresql config optimized for SSD (both run against
>SATA and NVMe raid), and an OpenStreetMap "planet" size
>database
>      on an HPZ840 dual CPU (S2) workstation that I managed to recently
>      acquire second hand from a refurbished hardware supplier.<br>
>    </p>
>    <p>Yes, I have a few bug cases open at ESRI support, including one
>     related to a very specific serious performance issue of one of the
>      geoprocessing tools, but none of that related to
>   'random_page_cost'. Also, as soon as you start upgrading the
>technical challenges to OpenStreetMap "planet" size
>databases,
>    ArcGIS certainly isn't the only software out there running into
>      issues here and there, QGIS does too, as well as many other
>     software packages. Handling > 500M record tables, just requires
>      thought, whatever toolbox you happen to open...</p>
>    <p>Marco<br>
>    </p>
>    <div>Op 22-5-2021 om 12:51 schreef Darafei
>      "Komяpa" Praliaskouski:<br>
>    </div>
>    <blockquote type="cite">
>      
>      <div dir="ltr">ESRI has multiple issues in itself that are
>        terrible to debug.
>        <div><br>
>          <div>A client of ours fights a bug where it can't browse
>            tables once you set random_page_cost to the SSD values of
>       1.1 instead of 4. So I guess if we're using a bit more index
>            scan than usual there may be an unknown problem that does
>            not show itself with QGIS and GeoServer.</div>
>          <div><br>
>          </div>
>        </div>
>      </div>
>      <br>
>      <div class="gmail_quote">
>        <div dir="ltr" class="gmail_attr">On Mon, May 17, 2021 at 10:05
>PM Regina Obe <<a href="mailto:lr at pcorp.us" target="_blank"
>rel="noreferrer">lr at pcorp.us</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">Has
>          anyone tried running PostgreSQL 13 with PostGIS 3.1 and using
>          ArcGIS Pro<br>
>          2.7 for editing?<br>
>          <br>
>          I gather from this that it is not supported?<br>
>          <br>
><a
>href="https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-postgresql.htm"
>rel="noreferrer noreferrer"
>target="_blank">https://desktop.arcgis.com/en/system-requirements/latest/database-requiremen<br>
>            ts-postgresql.htm</a><br>
>          <br>
>      I think for ST_Geometry type (ESRI's version) I would need to
>          stick with<br>
>         PostgreSQL 12 since they probably don't have PostgreSQL 13
>          binaries.<br>
>          <br>
>          But I assume even for that case PostgreSQL 12 / PostGIS 3.1
>          should work fine<br>
>          as it's not reliant on ESRI's libs.<br>
>          <br>
>          Thanks,<br>
>          Regina<br>
>          <br>
>          _______________________________________________<br>
>          postgis-users mailing list<br>
><a href="mailto:postgis-users at lists.osgeo.org" target="_blank"
>rel="noreferrer">postgis-users at lists.osgeo.org</a><br>
><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
>rel="noreferrer noreferrer"
>target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
>        </blockquote>
>      </div>
>      <br clear="all">
>      <div><br>
>      </div>
>      -- <br>
>      <div dir="ltr">
>        <div dir="ltr">Darafei "Komяpa" Praliaskouski<br>
>OSM BY Team - <a href="http://openstreetmap.by/" target="_blank"
>rel="noreferrer">http://openstreetmap.by/</a><br>
>        </div>
>      </div>
>      <br>
>      <fieldset></fieldset>
>      <pre>_______________________________________________
>postgis-users mailing list
><a href="mailto:postgis-users at lists.osgeo.org" target="_blank"
>rel="noreferrer">postgis-users at lists.osgeo.org</a>
><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
>target="_blank"
>rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
></pre>
>    </blockquote>
>  </div>
>
>_______________________________________________<br>
>postgis-users mailing list<br>
><a href="mailto:postgis-users at lists.osgeo.org" target="_blank"
>rel="noreferrer">postgis-users at lists.osgeo.org</a><br>
><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
>rel="noreferrer noreferrer"
>target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
></blockquote></div>
><pre class="blue"><hr /><br />postgis-users mailing list<br
>/>postgis-users at lists.osgeo.org<br /><a
>href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br
>/></pre>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210524/92bfa7e1/attachment.html>