shinichi

ERROR: Create Enterprise Geodatabase for PostgreSQL 9.1 on Linux Server

Discussion created by shinichi on Sep 13, 2013
Latest reply on Sep 18, 2013 by shinichi
Hi all,

I know that several users have similar issue and post it before.
I was really looking for the answer but none of them work for me. Can someone please give me some advice?

Here is a dialog message on ArcToolbox
Executing: CreateEnterpriseGeodatabase PostgreSQL xxx.xxx.com arcgisdb DATABASE_AUTH postgres ***** SDE_SCHEMA sde ***** # "C:\Program Files (x86)\ESRI\License10.1\sysgen\keycodes"
Start Time: Fri Sep 13 15:30:44 2013
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)
.


Here is my current environment.
Client/ArcGIS
ArcGIS for Desktop 10.1 Advanced on Win2008 R2 (64bit)
ArcGIS for Server 10.1 for Windows and SQL Server are installed on the same machine, but I'm transferring all data to Linux server.

Server
Linux Server: 64-bit CentOS5 (Red hat base)
ArcGIS for Server 10.1 Advanced for Linux
PostgreSQL 9.1.5

Note that since our linux server is located different place, pg_hda.conf is already edited. I can see databases (Postgresql on Linux) via pgAdminIII (on Windows).

by using pg_config, I made sure the PKGLIBDIR = /usr/lib/postgresql
I've also set up $SDEHOME = /home/xxx/arcgis/server
$PG_HOME = /usr/pgsql-9.1
Then, $LD_LIBRARY_PATH = /usr/lib/postgresql:/usr/pgsql-9.1/lib:/home/xxx/arcgis/server/lib:/usr/lib64/postgresql/
(Just in case, I added /usr/lib64/postgresql as well)

After this, I copy st_geometry.so and post it to /usr/lib/postgresql (see attached)
I also save it to /usr/pgsql-9.1/lib and /usr/lib64/postgresql just in case.
I copied and pasted by root user and set the access permission 755.

and I even restarted postgresql.
But the same result.

I also tested st_geometry.so from both ArcGIS Desktop machine and ArcGIS Server for Linux
C:\Program Files (x86)\ArcGIS\Desktop10.1\DatabaseSupport\PostgreSQL\9.1\Linux64\st_geometry.so
and
/home/xxx/arcgis/server/DatabaseSupport/PostgreSQL/9.1/Linux64/st_geometry.so

They didn't work.

What else should I try to figure out? Can someone give me some advice?

Attachments

Outcomes