Available with Standard or Advanced license.
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 user superuser authority in the database cluster if it does not already have it.
- Install a new release of the ArcGIS client 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 and open the Catalog window.
- Create a connection to your PostgreSQL database. Log in as the sde user.
- 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.