Setup st_geometry library ArcGIS version does not match the expected version in use

Error Message

When creating an enterprise geodatabase from ArcGIS Pro, st_geometry files are required in the lib directory of PostgreSQL. If there is a version compatibility between ArcGIS Pro and Enterprise Database (PostgreSQL). when using the tool Create Enterprise Geodatabase, the following errors may occur:

Setup st_geometry library ArcGIS version does not match the expected version in use [Success] st_geometry library release expected: 1.30.4.10, found: 1.30.5.10

or

Setup st_geometry library database version does not match the actual database version in use [Error: incompatible library "/usr/lib/postgresql/14/lib/st_geometry.so": version mismatch
DETAIL: Server is version 14, library is version 13, ::SQLSTATE=XX000

Note:
The version numbers indicated in the above errors are subject to change according to the version of software installed.

Cause

The error refers to the incorrect st_geometry file placed in lib directory. Each and every version of ArcGIS Pro has its own st_geometry file.

Note:
Even if the st_geometry is in higher version, ArcGIS Pro could give the error. ArcGIS Pro required the equivalent version of st_geometry file.

Solution or Workaround

For this issue it is required to install the correct version of the st_geometry files for the ArcGIS Pro version in use. For example, if ArcGIS Pro 3.2 is installed, download the ArcGIS Pro ST_Geometry Libraries (PostgreSQL) from the download page of ArcGIS Pro 3.2 only. Follow these steps:

1. Note the version of ArcGIS Pro and PostgreSQL version installed in the machine.
2. Download the correct version of the st_geometry file from My Esri, Downloads tab > All Products and Versions.
3. On the Products page, click the All versions tab.
4. Change the dropdown for ArcGIS Pro to the version that has been installed in the machine.
5. Under the section Database Support Files, download ArcGIS Pro ST_Geometry Libraries (PostgreSQL).
6. Unzip the folder once it is downloaded.
7. Based on the PostgreSQL version and Operating system find the correct st_geometry file.
8. Import ST_Geometry files in PostgreSQL:

• • For Windows Operating System, replace the st_geometry.dll file in the lib directory:

C:\Program Files\PostgreSQL\<version>\lib (Default location)

• For Linux Operating System, replace the st_geometry.so file in the lib directory. Run pg_config as the postgres user. The value that is returned for PKGLIBDIR is the lib directory.

9. Once the file is replaced, Run the Create Enterprise Geodatabase tool to create the enterprise geodatabase.