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

[Shaozhong SHI]

Hi, Andy,
Is there a definitive guide on how to set up PostGIS/PostgreSQL for ArcGIS
desktop users?  Are there definite technical documents or papers on this
topic?
Looking forward to hearing from you.
Regards,
Shao

On Wed, 21 Aug 2019 at 17:56, Andy Anderson <aanderson at amherst.edu> wrote:

> 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>
> 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> 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
>
> _______________________________________________
> 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/20190822/c8977a05/attachment.html>