Hi, Bobb, I am confused with this.
The idea is to use ArcGIS desktops to read data from PostGIS/PostgreSQL. How best to configure and make them happy to talk to each other? Regards, Shao On Wed, 21 Aug 2019 at 15:01, Basques, Bob (CI-StPaul) < bob.basq...@ci.stpaul.mn.us> wrote: > Shao, > > 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. > > 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. > > bobb > > > > > > On Aug 21, 2019, at 2:18 AM, Shaozhong SHI <shishaozh...@gmail.com> wrote: > > *Think Before You Click: *This email originated *outside *our > organization. > > Hi, Bob, > Can you point me to excellent technical documentation on what you > mentioned, so that I can double-check. > My colleagues have made it working, but there are some issues. For > instance, not all ArcGIS desktops can access and retrieve data. > > Looking forward to have more insight into this matter. > > Regards, > > Shao > > On Tue, 20 Aug 2019 at 17:08, Basques, Bob (CI-StPaul) < > bob.basq...@ci.stpaul.mn.us> wrote: > >> All, >> >> 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. >> >> 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. >> >> 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. >> >> Anyway, just my 2cents. >> >> bobb >> >> >> >> On Aug 20, 2019, at 10:12 AM, Shaozhong SHI <shishaozh...@gmail.com> >> wrote: >> >> *Think Before You Click: *This email originated *outside *our >> organization. >> >> How to ensure that all versions of ArcGIS desktop applications can access >> and read from server-based PostGIS/PostgreSQL? >> >> Regards, >> >> Shao >> _______________________________________________ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
