The ST_Geometry library can contain new functionality or fixes at each ArcGIS release. You can upgrade the ST_Geometry type in your PostgreSQL database using the Create Spatial Type geoprocessing tool or the CreateSpatialType ArcPy function.
- Grant the sde login role uperuser authority in the database cluster if it does not already have it.
- Install a new release of ArcGIS Desktop to obtain the new version of the st_geometry library.
- Make a backup copy of or rename the existing st_geometry library on the PostgreSQL server.
- Copy the new st_geometry library from the DatabaseSupport directory in
the ArcGIS client installation location, and place it in the
PostgreSQL lib directory.
- If PostgreSQL is installed on a Linux server, log in to the server as the root user and place the st_geometry.so file in the /usr/lib64/pgsql directory.
- If PostgreSQL is installed on a Windows server, place the st_geometry.dll file in the %PostgreSQL%\lib directory.
- Start ArcCatalog or ArcMap, open the Catalog window, and connect to the database as the sde user.
This creates an .sde file in C:\Users\<user_name>\AppData\Roaming\ESRI\Desktop<version_number>\ArcCatalog.
- To update the ST_Geometry type, subtypes, and functions in the database, run the Create Spatial Type geoprocessing tool or a Python script that uses the CreateSpatialType function and the .sde file you created in the last step.