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

[Shaozhong SHI]

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> 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> 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> 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>
>> 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
>> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> 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/77b92294/attachment.html>