<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
All,
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">Anyway, just my 2cents.</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On Aug 20, 2019, at 10:12 AM, Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" class="">shishaozhong@gmail.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="">
<table class="MsoNormalTable" border="1" cellpadding="0" style="background:#E2F700;border:solid black 1.0pt">
<tbody class="">
<tr class="">
<td style="border:none;padding:.75pt .75pt .75pt .75pt" class="">
<p class="MsoNormal"><strong class=""><span style="font-family:"Calibri",sans-serif;color:#FF3333" class="">Think Before You Click:
</span></strong>This email originated <strong class="">outside </strong>our organization.<o:p class=""></o:p></p>
</td>
</tr>
</tbody>
</table>
<br class="">
<div class="">
<div dir="ltr" class="">How to ensure that all versions of ArcGIS desktop applications can access and read from server-based PostGIS/PostgreSQL?
<div class=""><br class="">
</div>
<div class="">Regards,</div>
<div class=""><br class="">
</div>
<div class="">Shao</div>
</div>
</div>
</div>
_______________________________________________<br class="">
postgis-users mailing list<br class="">
<a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class="">
https://lists.osgeo.org/mailman/listinfo/postgis-users</div>
</blockquote>
</div>
<br class="">
</div>
</div>
</body>
</html>