<div dir="ltr">Hi, Bobb,<div><br></div><div>I am confused with this.</div><div><br></div><div>The idea is to use ArcGIS desktops to read data from PostGIS/PostgreSQL.</div><div><br></div><div>How best to configure and make them happy to talk to each other?</div><div><br></div><div>Regards,</div><div><br></div><div>Shao</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 21 Aug 2019 at 15:01, Basques, Bob (CI-StPaul) <<a href="mailto:bob.basques@ci.stpaul.mn.us">bob.basques@ci.stpaul.mn.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">
<div style="overflow-wrap: break-word;">
Shao,
<div><br>
</div>
<div>I had to dig fairly deeply into the ESRI site to find this particular explanation for why the service couldn’t/wouldn’t get connected. Just to be clear, we do use logins for accessing the database, we just have chosen to use the “postgres” (named)
database.
<div><br>
</div>
<div>So, I just went and tried to find the refence I found previously, and can’t find it (real quick). Anyway,as long as you don’t try to connect to the “postgres” database, things do seem to work ok.</div>
<div><br>
</div>
<div>bobb</div>
<div><br>
</div>
<div><br>
<div><br>
</div>
<div><br>
<div><br>
<blockquote type="cite">
<div>On Aug 21, 2019, at 2:18 AM, Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank">shishaozhong@gmail.com</a>> wrote:</div>
<br class="gmail-m_2243374280069712994Apple-interchange-newline">
<div>
<div>
<table class="gmail-m_2243374280069712994MsoNormalTable" border="1" cellpadding="0" style="background:rgb(226,247,0);border:1pt solid black">
<tbody>
<tr>
<td style="border:none;padding:0.75pt">
<p class="MsoNormal"><strong><span style="font-family:Calibri,sans-serif;color:rgb(255,51,51)">Think Before You Click:
</span></strong>This email originated <strong>outside </strong>our organization.<u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
<br>
<div>
<div dir="ltr">Hi, Bob,
<div>Can you point me to excellent technical documentation on what you mentioned, so that I can double-check.</div>
<div>My colleagues have made it working, but there are some issues. For instance, not all ArcGIS desktops can access and retrieve data.</div>
<div><br>
</div>
<div>Looking forward to have more insight into this matter.</div>
<div><br>
</div>
<div>Regards,</div>
<div><br>
</div>
<div>Shao</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, 20 Aug 2019 at 17:08, Basques, Bob (CI-StPaul) <<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.mn.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">
<div>All,
<div><br>
</div>
<div>One biggie, is that the ESRI side does not like connecting to the “postgres” named database, claiming it’s a System database (whatever that means). This is not readily available as a limitation either when looking for reasons why it won’t connect.
We’ve been using the “postgres” database name for years (a decade now??) with no ill effects from other applications/ connections. I sort of understand this from the commercial side having worked with other databases like Oracle and MSSQL, but still, there
should be a way to side step this with a setting somewhere.
<div><br>
</div>
<div>I looked high and low for a way to alias the “postgres” database name inside of Postgres, but didn’t find anything very easy to implement or maintain very easily. I did think about setting up another dataabase and using Views to the postgres
database, but that seemed like a bad idea for some reason, along with being somewhat hard to maintain, but upon reflection I keep coming back to the idea.</div>
<div><br>
</div>
<div>All non “postgres” named connections seem to work fine so far. Haven’t implemented anything yet that is really heavy duty as far as loading though, so who knows.</div>
<div><br>
</div>
<div>Anyway, just my 2cents.</div>
<div><br>
</div>
<div>bobb</div>
<div><br>
</div>
<div><br>
<div><br>
<blockquote type="cite">
<div>On Aug 20, 2019, at 10:12 AM, Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank">shishaozhong@gmail.com</a>> wrote:</div>
<br class="gmail-m_2243374280069712994gmail-m_6642160044412238955Apple-interchange-newline">
<div>
<div>
<table class="gmail-m_2243374280069712994gmail-m_6642160044412238955MsoNormalTable" border="1" cellpadding="0" style="background:rgb(226,247,0);border:1pt solid black">
<tbody>
<tr>
<td style="border:none;padding:0.75pt">
<p class="MsoNormal"><strong><span style="font-family:Calibri,sans-serif;color:rgb(255,51,51)">Think Before You Click:
</span></strong>This email originated <strong>outside </strong>our organization.<u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
<br>
<div>
<div dir="ltr">How to ensure that all versions of ArcGIS desktop applications can access and read from server-based PostGIS/PostgreSQL?
<div><br>
</div>
<div>Regards,</div>
<div><br>
</div>
<div>Shao</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" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</blockquote>
</div>
<br>
</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>
</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" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</blockquote>
</div>
<br>
</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>