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; } } }

Create Enterprise Geodatabase Error..

BryanKaraffa

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.. 🙂

Trouver plus de publications taguées avec

Accepted answers

BryanKaraffa

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.

All comments

BryanKaraffa

RyanClark

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.

LeilaJackson1_1-1636033855677.png

WesleyAntal2

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?

KimPeter

@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.

WesleyAntal2

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.

ArturMichorczyk

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

MichaelCarson4

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?

MichaelCarson4

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:

PatrickRoyer1

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.

MichaelCarson4

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?

PatrickRoyer

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.

MichaelCarson4

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.

MarkoMladineo

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?

MichaelCarson4

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/ .

VivekRaj

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.

MarkoMladineo

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

MichaelCarson4

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

MarkReddick

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

Navaneetha_KrishnanAsokan

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).

RebeccaStrauch__GISP

Navaneetha, since this thread is 2 years old and your issue is a little different, I would recommend creating a new thread with you error. You can include a link to this thread if you have already tried the steps outlined here. But as a new thread, you will likely get help directed at your issue.

By the way, I have seen that error before, but can't remember the cause or fix right now.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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