[postgis-users] ArcGIS desktop accessing and reading from PostGIS

[Andy Anderson]

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.basques at 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 <shishaozhong at gmail.com <mailto:shishaozhong at 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.basques at ci.stpaul.mn.us <mailto:bob.basques at 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 <shishaozhong at gmail.com <mailto:shishaozhong at 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.basques at ci.stpaul.mn.us <mailto:bob.basques at 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 <shishaozhong at gmail.com <mailto:shishaozhong at 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 at lists.osgeo.org <mailto:postgis-users at 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 at lists.osgeo.org <mailto:postgis-users at 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 at lists.osgeo.org <mailto:postgis-users at 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 at lists.osgeo.org <mailto:postgis-users at 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 at lists.osgeo.org <mailto:postgis-users at 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190821/3edf4a90/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 529 bytes
Desc: Message signed with OpenPGP
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190821/3edf4a90/attachment.sig>