Available with Standard or Advanced license.
You can upgrade the ST_Geometry type in your PostgreSQL database using the Create Spatial Typegeoprocessing tool or a Python script.
- Grant the sde user superuser privileges in the database if it does not already have them.
- 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.
- Open the Create Spatial Type tool.
You can use the Search window to search for the tool or open the tool from the Workspace toolset of the Data Management toolbox.
- Add the database connection you created in step 6 to the Database Connection File text box.
- Click OK to run the tool.
The ST_Geometry type, subtypes, and functions are now upgraded to the latest release.