Upgrading the ST_Geometry type in a PostgreSQL database

You can upgrade the ST_Geometry type in your PostgreSQL database using the Create Spatial Type geoprocessing tool or a Python script.

Steps:

1. Grant the sde user superuser privileges in the database if it does not already have them.
2. Install a new release of the ArcGIS client to obtain the new version of the st_geometry library.
3. Make a backup copy of or rename the existing st_geometry library on the PostgreSQL server.
4. 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.
5. Start ArcCatalog or ArcMap and open the Catalog window.
6. Create a connection to your PostgreSQL database. Log in as the sde user.
7. 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.

8. Add the database connection you created in step 6 to the Database Connection File text box.
9. Click OK to run the tool.

The ST_Geometry type, subtypes, and functions are now upgraded to the latest release.