topic Re: Create Enterprise Geodatabase Error.. in ArcGIS Enterprise Questions

Create Enterprise Geodatabase Error..

BryanKaraffa — Sun, 12 Dec 2021 16:20:46 GMT

I am trying to create my first enterprise geodatabase and I am using the tool. I have successfully made a connection with the administrator account (postgres) in ArcCatalog. Here is the results of the geoprocess:

Executing: CreateEnterpriseGeodatabase PostgreSQL star-ags icm DATABASE_AUTH postgres ***** SDE_SCHEMA sde ***** # "C:\Program Files\ESRI\License10.1\sysgen\keycodes"
Start Time: Mon Aug 06 15:13:53 2012
User has privileges required to create database objects.
Geodatabase admin user already exists.
Database already exists.
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.

Connected RDBMS instance is not setup for Esri spatial type configuration.
Failed to execute (CreateEnterpriseGeodatabase).
Failed at Mon Aug 06 15:13:54 2012 (Elapsed Time: 1.00 seconds)

The error reads:
You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.

Connected RDBMS instance is not setup for Esri spatial type configuration.

This is a fresh install of Desktop/Server 10.1 running alongside a fresh install of Postgres 9.0.5 (64bit). Anxiously awaiting a response.. 🙂

Re: Create Enterprise Geodatabase Error..

BryanKaraffa — Mon, 06 Aug 2012 21:56:30 GMT

Solved this issue after some searching... Perhaps the error should reference the help topic that contains the solution?

http://resources.arcgis.com/en/help/main/10.1/index.html#/Tutorial_Getting_started_with_geodatabases_in_PostgreSQL/002p000000t4000000/

SOLUTION:
Place the ST_Geometry libraries in the PostgreSQL lib directory

Geodatabase creation in PostgreSQL relies on the presence of the ST_Geometry library. You must place the appropriate library in the lib directory where PostgreSQL is installed before you can create a geodatabase. ST_Geometry libraries can be found in the DatabaseSupport folder of your ArcGIS client installation.

Since this tutorial assumes your PostgreSQL installation is on a Windows server, you will use the ST_Geometry library found in the Windows64 folder.
Steps:

    In Windows Explorer, navigate to the location of the Windows ST_Geometry library in your ArcGIS client installation directory.

    The default location for ArcGIS for Desktop on 64-bit Windows operating systems is C:\Program Files (x86)\ArcGIS\Desktop<release#>\DatabaseSupport\PostgreSQL\Windows64; on 32-bit Windows operating systems, it is C:\Program Files\ArcGIS\Desktop<release#>\DatabaseSupport\PostgreSQL\Windows64.
    Copy st_geometry.dll from this location.
    Navigate to the PostgreSQL lib directory on the database server and paste the library to that location.

    On Windows, the default location is C:\Program Files\PostgreSQL\9.0\lib.

Re: Create Enterprise Geodatabase Error..

RyanClark — Fri, 18 Jan 2013 20:30:45 GMT

I have PostgreSQL running on an Ubuntu server. PostgreSQL and PostGIS were installed via "apt-get install postgresql-9.1-postgis". Where to I need to put st_geometry.so in order for the "Enable Geodatabase" link to work? I've already been able to connect to the database in ArcCatalog, and I put st_geometry.so in /usr/lib/postgresql/9.1/lib/, but still the same error message.

Re: Create Enterprise Geodatabase Error..

WesleyAntal2 — Mon, 25 Feb 2013 12:38:54 GMT

Solved this issue after some searching... Perhaps the error should reference the help topic that contains the solution?

http://resources.arcgis.com/en/help/main/10.1/index.html#/Tutorial_Getting_started_with_geodatabases_in_PostgreSQL/002p000000t4000000/

SOLUTION:
Place the ST_Geometry libraries in the PostgreSQL lib directory

Geodatabase creation in PostgreSQL relies on the presence of the ST_Geometry library. You must place the appropriate library in the lib directory where PostgreSQL is installed before you can create a geodatabase. ST_Geometry libraries can be found in the DatabaseSupport folder of your ArcGIS client installation.

Since this tutorial assumes your PostgreSQL installation is on a Windows server, you will use the ST_Geometry library found in the Windows64 folder.
Steps:

    In Windows Explorer, navigate to the location of the Windows ST_Geometry library in your ArcGIS client installation directory.

    The default location for ArcGIS for Desktop on 64-bit Windows operating systems is C:\Program Files (x86)\ArcGIS\Desktop<release#>\DatabaseSupport\PostgreSQL\Windows64; on 32-bit Windows operating systems, it is C:\Program Files\ArcGIS\Desktop<release#>\DatabaseSupport\PostgreSQL\Windows64.
    Copy st_geometry.dll from this location.
    Navigate to the PostgreSQL lib directory on the database server and paste the library to that location.

    On Windows, the default location is C:\Program Files\PostgreSQL\9.0\lib.

I installed postgres 9.0 and postgis 1.5, both for windows x86.
This DLL is in directory C:\Program Files\PostgreSQL\9.0\lib, but the error in creation of Geodatabase Enterprise continued. Exists conflict of architecture of DLL with the database?

Re: Create Enterprise Geodatabase Error..

KimPeter — Tue, 19 Mar 2013 02:02:12 GMT

@Wesley:
At 10.1, only 64-bit versions of the database are supported. The ST_Geometry library is 64-bit only; I'm pretty sure that it will not work with a 32-bit installation of PostgreSQL.

As a tip for when you install a 64-bit database cluster...I'm assuming that since you installed PostGIS that you want to use the geometry type for data storage(?) If so, be sure to pre-create your database using the PostGIS template before running the tool to create a geodatabase. The Create Enterprise Geodatabase tool uses the default PostgreSQL template database to create the database, which will not include PostGIS. (You'll still have to copy over the ST_Geometry library for the tool to run, but you don't have to use the ST_Geometry storage type once the geodatabase is created.)

@Ryan:
You should be able to run pg_config when logged in as the postgres user to determine which location to place the st_geometry.so file. (I say should because Ubuntu isn't technically supported, so I don't know for sure this will work in this case.) Also, be sure you copied the 9.1 version of the file since you indicated that you are using PostgreSQL 9.1.

@Bryan:
The topic you mention is a tutorial, specific to one particular OS and DBMS version; we wouldn't want to link to it from the error since it isn't applicable to all situations. HOWEVER, if the message still says "You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL software location...", we gotta fix that, since there aren't any other libraries you need to copy. I'll check on that and open a bug to fix the message if necessary.

Re: Create Enterprise Geodatabase Error..

WesleyAntal2 — Tue, 19 Mar 2013 19:48:06 GMT

I installed postgres 9.1, postgis 2.0 and ArcSDE 10.1 in architecture x64 (http://support.esri.com/en/knowledgebase/techarticles/detail/40553)
I create my database with the script:

CREATE DATABASE my_database
WITH OWNER = postgres
ENCODING = 'UTF8'
TEMPLATE = template_postgis_20 TABLESPACE = [...];

The server is Windows 2008 R2 Standard (http://resources.arcgis.com/en/help/system-requirements/10.1/index.html#//015100000075000000), but when I try create Geodatabase, this error is show:

"You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.

Connected RDBMS instance is not setup for Esri spatial type configuration.
Failed to execute (CreateEnterpriseGeodatabase)."

I try put DLL's st_geometry and libst_raster_pg of ArcSDE, but too not worked. Too try the DLL st_geometry in directory client and not worked.

Re: Create Enterprise Geodatabase Error..

ArturMichorczyk — Tue, 28 May 2013 06:27:55 GMT

Hi,
Place the ST_GEOMETRY libraries in the PostgreSQL lib directory from:
1. For PostgreSQL 9.0.x with directory c:\Program Files (x86)\ArcGIS\Desktop10.1\DatabaseSupport\PostgreSQL\Windows64\
2. For PostgreSQL 9.1.x with directory c:\Program Files (x86)\ArcGIS\Desktop10.1\DatabaseSupport\PostgreSQL\9.1\Windows64\
Regards
Artur

Re: Create Enterprise Geodatabase Error..

MichaelCarson4 — Wed, 29 May 2013 22:02:15 GMT

Hi,
Place the ST_GEOMETRY libraries in the PostgreSQL lib directory from:
1. For PostgreSQL 9.0.x with directory c:\Program Files (x86)\ArcGIS\Desktop10.1\DatabaseSupport\PostgreSQL\Windows64\
2. For PostgreSQL 9.1.x with directory c:\Program Files (x86)\ArcGIS\Desktop10.1\DatabaseSupport\PostgreSQL\9.1\Windows64\
Regards
Artur

I'm having the same problem as others ... Yes I put the st_geometry.dll file in the PostgreSQL\9.1\lib directory on my server and still get the "must copy the latest ST_GEOMETRY" error using the create enterprise geodatabase tool. Now what?

Re: Create Enterprise Geodatabase Error..

MichaelCarson4 — Wed, 29 May 2013 22:39:47 GMT

I'm having the same problem as others ... Yes I put the st_geometry.dll file in the PostgreSQL\9.1\lib directory on my server and still get the "must copy the latest ST_GEOMETRY" error using the create enterprise geodatabase tool. Now what?

Reinstalled PostgreSQL and copied st_geometry.dll over again. This time it worked. Go figure! :cool:

Re: Create Enterprise Geodatabase Error..

PatrickRoyer1 — Wed, 12 Jun 2013 18:25:56 GMT

It is with great misfortune that I am getting the same errors as well.
And there doesn't seem to be a technical support person at ESRI capable of getting through.

Please let me know if any one finds a solution. PostGres/PostGIS is such a fabulous tool.

Re: Create Enterprise Geodatabase Error..

MichaelCarson4 — Wed, 12 Jun 2013 19:22:20 GMT

It is with great misfortune that I am getting the same errors as well.
And there doesn't seem to be a technical support person at ESRI capable of getting through.

Please let me know if any one finds a solution. PostGres/PostGIS is such a fabulous tool.

Hi Proyer. Are you using Windows or Linux and what version? Also what version of PostgreSQL did you install?

Re: Create Enterprise Geodatabase Error..

PatrickRoyer — Wed, 12 Jun 2013 19:59:46 GMT

Hi Michael;

Thanks for responding. I am using Windows Server 2008R. I have installed all the client libraries, and have the .dll in the postgres lib path. I can create a new enterprise database, but can't enable an existing PostGres/PostGIS database.

I've now tried it with both Postgres 9.0 and 9.1.

Re: Create Enterprise Geodatabase Error..

MichaelCarson4 — Wed, 12 Jun 2013 21:50:11 GMT

Hi Michael;

Thanks for responding. I am using Windows Server 2008R. I have installed all the client libraries, and have the .dll in the postgres lib path. I can create a new enterprise database, but can't enable an existing PostGres/PostGIS database.

I've now tried it with both Postgres 9.0 and 9.1.

So it sounds like you were able to get the ST_GEOMETRY libraries installed and were successful in creating a new enterprise geodatabase. Now you are trying to enable a PostGIS database? I did not install PostGIS since I did not need OGC Simple Features. I assume you are using ArcGIS Desktop 10.1? Just in case you did not read yet, there is some great help setting up PostGIS here: http://resources.arcgis.com/en/help/main/10.1/index.html#//002p0000006v000000. Also, make sure you are using the right PostGIS version with your PostgreSQL version, ArcGIS version, Windows Server version: http://support.esri.com/en/knowledgebase/techarticles/detail/40553.

Re: Create Enterprise Geodatabase Error..

MarkoMladineo — Wed, 11 Dec 2013 08:54:23 GMT

I'm having the same ST_GEOMETRY problem on ArcGIS Server 10.1 on Linux:

You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.
Connected RDBMS instance is not setup for Esri spatial type configuration.

My configuration is:
ArcGIS Server 10.1. on Linux CentOS 6.0
ArcGIS Desktop 10.2 on Windows 8.1
PostgreSQL 9.0
ST_GEOMETRY 9.0 with all permissions set
PostgreSQL Windows binaries 9.0

Does ESRI have some special version of PostgreSQL?
Does anyone have any idea what to try?

Re: Create Enterprise Geodatabase Error..

MichaelCarson4 — Wed, 11 Dec 2013 13:45:38 GMT

Hi Marko. I see you are using ArcGIS Server 10.1 and ArcGIS Desktop 10.2. I believe for things to work together, all your ArcGIS software needs to be of the same version ... at least that is what ESRI says when they release a new version or service pack.

That being said, you should be able to find the proper ST_GEOMETRY.SO file for your Linux server under your ArcGIS Server 10.1 install directory (its in a directory like arcgis/server/databasesupport/postgresql) and place it your PostgreSQL lib directory. Just follow the instructions for a Linux server here:
'>http://resources.arcgis.com/en/help/main/10.1/index.html#/Setting_up_a_geodatabase_in_PostgreSQL/002p00000001000000/

I also noticed that you are using Linux CentOS 6.0. I don't think that is supported. See http://resources.arcgis.com/en/help/system-requirements/10.1/index.html#/PostgreSQL_Database_Requirements/015100000075000000/ .

Re: Create Enterprise Geodatabase Error.. in PostgreSQL 9.2 using ArcCalaog 10.2

VivekRaj — Mon, 20 Jan 2014 06:23:05 GMT

Getting error while creating enterprise database

When i try to create enterprise database using ArcCalaog 10.2 then it gives error
"You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL softeware location. "

I have already copied ST_GEOMETRY.dll in PostgreSQL lib directory from C:\Program Files\ArcGIS\Desktop<release#>\DatabaseSupport\PostgreSQL\Windows64, but still problem is same.

And also DLL's which is needed in ArcGIS client system is already copied in bin directory.

My Configuration details are:
Windows server 2008R2 Standard 64bit
PostgreSQl 9.2 64 bit
PostGIS 2.0
ArcGIS 10.2
ArcCalaog 10.2

Many thanks if anybody help me to fix this issue.

Re: Create Enterprise Geodatabase Error.. in PostgreSQL 9.2 using ArcCalaog 10.2

MarkoMladineo — Tue, 21 Jan 2014 10:12:35 GMT

Getting error while creating enterprise database
When i try to create enterprise database using ArcCalaog 10.2 then it gives error
"You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL softeware location. "

My Configuration details are:
PostgreSQl 9.2 64 bit

I'm not sure if PostgreSQL 9.2 is supported. Try PostgreSQL 9.1 or 9.0.

Unfortunately, I have same problem on Linux, as I've mentioned above. I still haven't solve it.

Marko

Re: Create Enterprise Geodatabase Error.. in PostgreSQL 9.2 using ArcCalaog 10.2

MichaelCarson4 — Wed, 22 Jan 2014 13:53:49 GMT

Try using the DLL under C:\Program Files\ArcGIS\Server\DatabaseSupport\PostgreSQL\9.2\Windows64 and place it in the lib directory for your PostgreSQL install. -mike

Re: Create Enterprise Geodatabase Error.. in PostgreSQL 9.2 using ArcCalaog 10.2

MarkReddick — Tue, 01 Apr 2014 22:16:10 GMT

Try using the DLL under C:\Program Files\ArcGIS\Server\DatabaseSupport\PostgreSQL\9.2\Windows64 and place it in the lib directory for your PostgreSQL install. -mike

Michael this was the perfect solution for me. Copying from the desktop database support files did not work. Copying from the server database support files location did! thank you! Both files appear to be the same size but something must be different.

mark

Re: Create Enterprise Geodatabase Error..

Navaneetha_KrishnanAsokan — Fri, 01 Apr 2016 09:02:14 GMT

Having Configurations - Arcgis 10.1

postgresql-9.0.23-1-windows-x64

Properly copied st_geometry.dll to C:\Program Files\PostgreSQL\9.0\lib

Getting Error while running the Tool - CreateEnterpriseGeodatabase

User has privileges required to create database objects.

Geodatabase admin user already exists.

Database created.

Error connecting to database as geodatabase admin

Failed to execute (CreateEnterpriseGeodatabase).