topic Re: Is it possible to connect directly to the PostgreSQL database? in ArcGIS Online Questions

Is it possible to connect directly to the PostgreSQL database?

RomanChueh — Tue, 30 Aug 2016 02:43:39 GMT

I would like use ArcGIS Data Store for my services, and I am wondering if there is any way to create a Database connection from ArcCatalog or ArcMap to the PostgreSQL database?

Re: Is it possible to connect directly to the PostgreSQL database?

AdrianWelsh — Tue, 30 Aug 2016 04:16:03 GMT

Roman,

Have you seen this article?

Connect to PostgreSQL from ArcGIS—Help | ArcGIS for Desktop

Re: Is it possible to connect directly to the PostgreSQL database?

JonathanQuinn — Wed, 07 Sep 2016 23:37:27 GMT

What are you interested in seeing when you connect to Data Store directly? The Data Store is designed so you don't really need to connect to it to perform any maintenance or anything like that, so it'd be good to know your use case for connecting.

Re: Is it possible to connect directly to the PostgreSQL database?

RomanChueh — Mon, 12 Sep 2016 18:03:25 GMT

Yes, but I don't have much experience working with PostgreSQL database. I installed pgAdmin III on the same machine as I have ArcGIS Data Stored installed. When I tried to add this server to the pgAdmin III, I am getting following error:

The server doesn't accept connections: the connection library reports:

"could not connect to server: connection refused (0x0000274D/10061) Is the server running on host "XXX.XXX.XXX.XXX" and accepting TCP/IP connection on port 5432"

Is there something I need to do first to connect to the PostgreSQL database?

Re: Is it possible to connect directly to the PostgreSQL database?

RomanChueh — Mon, 12 Sep 2016 18:18:11 GMT

I would like to connect the database directly to generate reports using Crystal Report or JasperReport, and extract data for dashboard analytics.

Thanks.