arcsde install with postgres

treter — Wed, 21 Apr 2010 09:12:30 GMT

Hello,

i have installed arcsde on windows xp sp3. Post-install program sdesetup works fine with postgresql on the same computer.

But i have to make it work with postgres on another computer (Windows 2003 server sp2, postgres 8.3 & postgis 1.3). When launching sdesetup -s 192.168.11.111, i have the message :

ERROR: Underlyinf DMS error (-51).
ERROR: SDE release install not completed.

the SDE log isn't helpfull.
the Postgres log says :

2010-04-21 10:21:23 CEST ERROR: relation "sde.sde_server_config" does not exist
2010-04-21 10:21:23 CEST STATEMENT: select count(1) from aamp2.sde.sde_server_config
2010-04-21 10:21:23 CEST ERROR: function aamp2.sde.sde_purge_processes() does not exist at character 8
2010-04-21 10:21:23 CEST HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2010-04-21 10:21:23 CEST STATEMENT: SELECT aamp2.sde.SDE_purge_processes ()
2010-04-21 10:21:23 CEST ERROR: relation "sde.sde_version" does not exist
2010-04-21 10:21:23 CEST STATEMENT: SELECT major, minor, bugfix, description, release, sdesvr_rel_low FROM aamp2.sde.sde_version
2010-04-21 10:21:23 CEST ERROR: relation "sde.sde_dbtune" does not exist
2010-04-21 10:21:23 CEST STATEMENT: select count(keyword) from aamp2.sde.sde_dbtune
2010-04-21 10:21:23 CEST ERROR: relation "sde.sde_server_config" does not exist
2010-04-21 10:21:23 CEST STATEMENT: select count(1) from aamp2.sde.sde_server_config
2010-04-21 10:21:23 CEST ERROR: type "st_geometry" does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_Out(st_geometry) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_geometry_in(cstring) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_In(cstring) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_geometry_recv(internal) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_Recv(internal) CASCADE
2010-04-21 10:21:23 CEST ERROR: type "st_geometry" does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_Send(st_geometry) CASCADE
2010-04-21 10:21:23 CEST ERROR: type "st_envelope" does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_ENVELOPE_Out(st_envelope) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_envelope_in(cstring) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_ENVELOPE_In(cstring) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_register_spatial_column(text, text, text, text, integer) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_register_spatial_column(text, text, text, text, int) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_unregister_spatial_column(text, text, text, text) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_unregister_spatial_column(text, text, text, text) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_isregistered_spatial_column(text, text, text, text, integer) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_isregistered_spatial_column(text, text, text, text, int) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_refresh_cache() does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_refresh_cache() CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_equalsrs(integer, integer) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_EqualSRS(int, int) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_geo_analyze(internal) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION st_geo_analyze(internal) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_geometry_version() does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_Version( ) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_geometry_release() does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_Release( ) CASCADE
2010-04-21 10:21:23 CEST ERROR: could not load library "C:/Program Files/PostgreSQL/8.3/lib/st_geometry.dll": unknown error 5
2010-04-21 10:21:23 CEST STATEMENT: CREATE OR REPLACE FUNCTION ST_GEOMETRY_IN(cstring)
RETURNS opaque AS 'st_geometry', 'ST_Geometry_In'
LANGUAGE 'C' WITH (ISCACHABLE, ISSTRICT)
2010-04-21 10:21:23 CEST LOG: could not receive data from client: Unknown winsock error 10061
2010-04-21 10:21:23 CEST LOG: unexpected EOF on client connection
2010-04-21 10:21:23 CEST LOG: could not receive data from client: Unknown winsock error 10061
2010-04-21 10:21:23 CEST LOG: unexpected EOF on client connection

and I can't understand what happens.
I made that install previously on similar configuration and it worked well.

any idea ?
thanks

bertrand

arcsde install with postgres

KimPeter — Thu, 29 Apr 2010 15:45:56 GMT

Hi Bertrand,

Did you copy the ST_Geometry library to the PostgreSQL lib directory? If ArcSDE and PostgreSQL are on different servers, you have to manually copy the library. See the section in the ArcSDE for PostgreSQL installation guide on installing ArcSDE and PostgreSQL on different servers.

-Kim

topic arcsde install with postgres in Data Management Questions

arcsde install with postgres

arcsde install with postgres