<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="">
Shao,
<div class=""><br class="">
</div>
<div class="">I’ve been able to overload a ESRI server in the past (on multiple occasions) by assuming the ESRI services can keep up with the same types of calls that I’ve used for Open Source based services. I’m sure that the services can be configured to
handle these types of requests, but it usually is non-typical coniguration or ends up costing more money for an additional module. </div>
<div class=""><br class="">
</div>
<div class="">Anyway, I haven’t tried running a service connection to postgres from the ESRI side in any sort of high load configuration yet. Mostly because I’m not the service admin.</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On Aug 20, 2019, at 3:36 PM, 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="">Why do you think loading is a heavy duty?
<div class=""><br class="">
<br class="">
On Tuesday, 20 August 2019, Basques, Bob (CI-StPaul) <<a href="mailto:bob.basques@ci.stpaul.mn.us" class="">bob.basques@ci.stpaul.mn.us</a>> wrote:<br class="">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word;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 class=""><br class="">
<blockquote type="cite" class="">
<div class="">On Aug 20, 2019, at 10:12 AM, Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank" class="">shishaozhong@gmail.com</a>> wrote:</div>
<br class="">
<div class="">
<div class="">
<table border="1" cellpadding="0" style="background:#e2f700;border:solid black 1.0pt" class="">
<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.<u class=""></u><u class=""></u></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>
______________________________<wbr class="">_________________<br class="">
postgis-users mailing list<br class="">
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" class="">postgis-users@lists.osgeo.org</a><br class="">
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" class="">https://lists.osgeo.org/<wbr class="">mailman/listinfo/postgis-users</a></div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</blockquote>
</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>
</body>
</html>