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.
— Andy > On Aug 21, 2019, at 12:23 PM, Basques, Bob (CI-StPaul) > <bob.basq...@ci.stpaul.mn.us> wrote: > > 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. > > As long as you don’t try connecting to the default “postgres” database, all > seem to work fine. > > bobb > > > >> On Aug 21, 2019, at 10:59 AM, Shaozhong SHI <shishaozh...@gmail.com >> <mailto:shishaozh...@gmail.com>> wrote: >> >> Think Before You Click: This email originated outside our organization. >> >> >> 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 <mailto: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 >>> <mailto: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 <mailto: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 >>>> <mailto: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 <mailto:postgis-users@lists.osgeo.org> >>>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>>> <https://lists.osgeo.org/mailman/listinfo/postgis-users> >>> _______________________________________________ >>> postgis-users mailing list >>> postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>> <https://lists.osgeo.org/mailman/listinfo/postgis-users>_______________________________________________ >>> postgis-users mailing list >>> postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>> <https://lists.osgeo.org/mailman/listinfo/postgis-users> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> <https://lists.osgeo.org/mailman/listinfo/postgis-users>_______________________________________________ >> postgis-users mailing list >> postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> <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
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
