nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I enable an Enterprise Geodatabase in a PostgreSQL with PostGIS installed?

AndrewClark2

Hi All,

I have ArcGIS Desktop 10.6.1 installed on one server where I also have ArcGIS Enterprise 10.6 installed. On a separate server, I also have PostgreSQL 10.3 installed with PostGIS 2.4 Installed. I would like to enable the Enterprise Geodatabase in the PostgreSQL database (which has an SDE username installed with full admin/ownership privileges) so I can integrate the database with Portal and Insights. I have been told by ESRI Technical Support that I do not need ST_geometry installed because I already have the PostGIS extension installed in the database, but every time I try to enable the Geodatabase through ArcCatalog i crashes with the error message: "You must copy the latest ST_GEOMETRY library to the PostgreSQL software location."

Please help!

Andrew

Find more posts tagged with

Accepted answers

All comments

George_Thompson

You must install the ST_Geometry libraries as some of the system tables use that geometry type and it is set to that as the DEFAULT config keyword.

Here is outlined int he help doc: Create a geodatabase in PostgreSQL on Windows—Help | ArcGIS Desktop

Configure it and report back. Thanks!

AndrewClark2

So essentially it will have 2 spatial libraries installed? Can it not be configured just using POSTGIS?

George_Thompson

I do not think that it can if you want the Enterprise geodatabase functionality in the Postgres DB. We can read the PostGIS spatial type in the software, but not edit without the geodatabase functionality installed. Here is some more information on that; Geodatabases in PostgreSQL—Help | ArcGIS Desktop

You can create a geodatabase in your existing PostgreSQL database and continue to store your nongeodatabase data alongside geodatabase data. You can view and publish both types of data in ArcGIS Desktop, but be aware of the following:
Geodatabase data can be edited in ArcGIS Desktop but database data cannot.
If your database contains geodatabase system tables, ArcGIS considers it a geodatabase. Therefore, even if you are connecting to tables that are not registered with the geodatabase, ArcGIS client and geodatabase release compatibility rules still apply.

You can enable the Enterprise geodatabase and set your DEFAULT data load type to PG_Geometry using the keywords.

Configuration keywords—Help | ArcGIS Desktop

PostgreSQL configuration parameters—Help | ArcGIS Desktop - Look at Geometry storage parameters

Enterprise GIS‌

VinceAngelo

An Enterprise geodatabase can only be configured without Esri SDE.ST_Geometry support when using RDS (Amazon PostgreSQL Database-as-a-Service). If you just want PG-based support Query Layers (without any geodatabase functionality) then you don't need to create the sde login/schema or run Enable Enterprise Geodatabase.

- V

AndrewClark2

This makes sense. What I actually want to do is publish the database to

portal so I can connect it to Insight. Is this the best way to do it?

AndrewClark2

Hi all!

I got this working!!!! Thanks for your help.

Next steps:

I am trying to now connect this Enterprise Geodatabase to ArcGIS Insights through ArcGIS Portal. I have registered the Enterprise geodatabase to ArcServer and created a Geodata Service which I can view on my Portal. Now the issue is that when I am in Portal, I have no way to actually view the data. Even when viewing the service in Desktop, I cannot open the actual database tables. Any advice would be appreciated.

Cheers,

Andrew

George_Thompson

Did you publish services to Portal?

I do not think that Portal will be able to see a Geodata service directly within the interface. Did you publish a map service with the geodata service? Publishing a geodata service with a map service—Documentation | ArcGIS Enterprise

What is a geodata service?—Documentation | ArcGIS Enterprise

Geodata service usage—Documentation | ArcGIS Enterprise

Suggestions for configuring geodata services—Documentation | ArcGIS Enterprise

What is your ultimate goal with a Geodata service?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.