<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="">The postgres database is set up by default by the postgres server and holds configuration information: databases, users, etc. Don’t touch. Set up another database for Arc to use.<div class=""><br class=""></div><div class="">— Andy<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Aug 21, 2019, at 12:23 PM, Basques, Bob (CI-StPaul) <<a href="mailto:bob.basques@ci.stpaul.mn.us" class="">bob.basques@ci.stpaul.mn.us</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
That’s what I’m talking about. when I first tried to connect to Posters (and the “postgres” named database, I kept getting an error from ArcGIS saying the the “postgres” name for a database was a bad thing, and it wouldn’t connect. After much searching, I
discover that the name, “postgres” for a database wasn’t allowed by the ArcGIS client to connect to.
<div class=""><br class="">
</div>
<div class="">As long as you don’t try connecting to the default “postgres” database, all seem to work fine.</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 21, 2019, at 10:59 AM, Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" class="">shishaozhong@gmail.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<table class="MsoNormalTable" border="1" cellpadding="0" style="caret-color: rgb(0, 0, 0); font-family: ComicSansMS; letter-spacing: normal; orphans: auto; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; background-color: rgb(226, 247, 0); border: 1pt solid black; background-position: initial initial; background-repeat: initial initial;">
<tbody class="">
<tr class="">
<td style="border: none; padding: 0.75pt;" class=""><p class="MsoNormal"><strong class=""><span style="font-family: Calibri, sans-serif; color: rgb(255, 51, 51);" class="">Think Before You Click:<span class="Apple-converted-space"> </span></span></strong>This email originated<span class="Apple-converted-space"> </span><strong class="">outside<span class="Apple-converted-space"> </span></strong>our
organization.<o:p class=""></o:p></p>
</td>
</tr>
</tbody>
</table>
<br style="caret-color: rgb(0, 0, 0); font-family: ComicSansMS; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<div style="caret-color: rgb(0, 0, 0); font-family: ComicSansMS; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<div dir="ltr" class="">Hi, Bobb,
<div class=""><br class="">
</div>
<div class="">I am confused with this.</div>
<div class=""><br class="">
</div>
<div class="">The idea is to use ArcGIS desktops to read data from PostGIS/PostgreSQL.</div>
<div class=""><br class="">
</div>
<div class="">How best to configure and make them happy to talk to each other?</div>
<div class=""><br class="">
</div>
<div class="">Regards,</div>
<div class=""><br class="">
</div>
<div class="">Shao</div>
</div>
<br class="">
<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" class="">bob.basques@ci.stpaul.mn.us</a>> wrote:<br class="">
</div>
<blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;">
<div style="overflow-wrap: break-word;" class="">Shao,
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class=""><br class="">
<blockquote type="cite" class="">
<div class="">On Aug 21, 2019, at 2:18 AM, Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank" class="">shishaozhong@gmail.com</a>> wrote:</div>
<br class="gmail-m_2243374280069712994Apple-interchange-newline">
<div class="">
<div class="">
<table class="gmail-m_2243374280069712994MsoNormalTable" border="1" cellpadding="0" style="background-color: rgb(226, 247, 0); border: 1pt solid black; background-position: initial initial; background-repeat: initial initial;">
<tbody class="">
<tr class="">
<td style="border: none; padding: 0.75pt;" class=""><p class="MsoNormal"><strong class=""><span style="font-family: Calibri, sans-serif; color: rgb(255, 51, 51);" class="">Think Before You Click:<span class="Apple-converted-space"> </span></span></strong>This email originated<span class="Apple-converted-space"> </span><strong class="">outside<span class="Apple-converted-space"> </span></strong>our
organization.<u class=""></u><u class=""></u></p>
</td>
</tr>
</tbody>
</table>
<br class="">
<div class="">
<div dir="ltr" class="">Hi, Bob,
<div class="">Can you point me to excellent technical documentation on what you mentioned, so that I can double-check.</div>
<div class="">My colleagues have made it working, but there are some issues. For instance, not all ArcGIS desktops can access and retrieve data.</div>
<div class=""><br class="">
</div>
<div class="">Looking forward to have more insight into this matter.</div>
<div class=""><br class="">
</div>
<div class="">Regards,</div>
<div class=""><br class="">
</div>
<div class="">Shao</div>
</div>
<br class="">
<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" class="">bob.basques@ci.stpaul.mn.us</a>> wrote:<br class="">
</div>
<blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;">
<div 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="gmail-m_2243374280069712994gmail-m_6642160044412238955Apple-interchange-newline">
<div class="">
<div class="">
<table class="gmail-m_2243374280069712994gmail-m_6642160044412238955MsoNormalTable" border="1" cellpadding="0" style="background-color: rgb(226, 247, 0); border: 1pt solid black; background-position: initial initial; background-repeat: initial initial;">
<tbody class="">
<tr class="">
<td style="border: none; padding: 0.75pt;" class=""><p class="MsoNormal"><strong class=""><span style="font-family: Calibri, sans-serif; color: rgb(255, 51, 51);" class="">Think Before You Click:<span class="Apple-converted-space"> </span></span></strong>This email originated<span class="Apple-converted-space"> </span><strong class="">outside<span class="Apple-converted-space"> </span></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>
_______________________________________________<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/mailman/listinfo/postgis-users</a></div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
_______________________________________________<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" rel="noreferrer" target="_blank" class="">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
</div>
</div>
_______________________________________________<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/mailman/listinfo/postgis-users</a></div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</div>
_______________________________________________<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" rel="noreferrer" target="_blank" class="">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
</div>
<span style="caret-color: rgb(0, 0, 0); font-family: ComicSansMS; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: ComicSansMS; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<span style="caret-color: rgb(0, 0, 0); font-family: ComicSansMS; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">postgis-users
mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: ComicSansMS; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<a href="mailto:postgis-users@lists.osgeo.org" style="font-family: ComicSansMS; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">postgis-users@lists.osgeo.org</a><br style="caret-color: rgb(0, 0, 0); font-family: ComicSansMS; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" style="font-family: ComicSansMS; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</blockquote>
</div>
<br class="">
</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>