I'm attempting to upgrade my ArcSDE 10 PostgreSQL/PostGIS database to ArcSDE 10.1 using the instructions here. The top of the error log from the PostgreSQL upgrade is as follows:ERROR: function st_geometry_in(cstring) does not exist
ERROR: type "st_geometry" is only a shell
ERROR: type "sde.st_geomcollection" does not exist
ERROR: type "st_geometry" is only a shell
ERROR: type "sde.st_linestring" does not exist
ERROR: type "st_geometry" is only a shell
ERROR: type "sde.st_multilinestring" does not exist
ERROR: type "st_geometry" is only a shell
ERROR: type "sde.st_multipoint" does not exist
ERROR: type "st_geometry" is only a shell
ERROR: type "sde.st_multipolygon" does not exist
ERROR: type "st_geometry" is only a shell
ERROR: type "sde.st_point" does not exist
ERROR: type "st_geometry" is only a shell
ERROR: type "sde.st_polygon" does not exist
ERROR: type st_geomcollection does not exist
ERROR: type "st_geomcollection" does not exist
ERROR: type st_geomcollection does not exist
ERROR: type "st_geomcollection" does not exist
ERROR: type st_geomcollection does not exist
ERROR: type "st_geomcollection" does not exist
ERROR: type st_geomcollection does not exist
ERROR: type "st_geomcollection" does not exist
ERROR: SQL function cannot accept shell type st_geometry
These errors lead me to believe it has something to do with the st_geometry.dll provided by Esri rather than a PostGIS issue. Regardless of the errors, it appears that all my feature classes and tables have been restored successfully. However, I cannot connect to the PostgreSQL database to upgrade to 10.1. When I attempt the direct connection in ArcCatalog, I receive an error box saying:Failed to connect to the specified server. Do you want to continue?
This release of the GeoDatabase is either invalid or out of date.
DBMS table not found [<<mydb>>.sde.GDB_Release]
I can click "Yes" or "No" in the error box, but neither option opens the database.I'm migrating from PostgreSQL 8.3 to 9.1 and PostGIS 1.5 to PostGIS 2.0. My server is running Windows 2003 R2 SP2 64 bit with ArcGIS Server 10.1 SP1 installed, and my client machine is running Windows XP 32 bit with ArcGIS Desktop 10.1 SP1 installed. I have copied the 9.1 Windows 64 bit st_geometry to the PostgreSQL library directory on the server and I have copied the 32 bit PostgreSQL client libraries to my ArcGIS Desktop/bin folder on my client machine.Thanks.
