Setup and Create an ArcGIS Enterprise Geodatabase in PostgreSQL


To Setup and Create an ArcGIS Enterprise Geodatabase in PostgreSQL follow the following steps:

 

Step 1: Download and Install PostgreSQL setup

Tip: Download and install PostgreSQL as per windows bit size, (Windows x86-64 or Windows x86-32)

You will create a username and password for the postgres superuser or administrator during the installation. Be sure to remember this password, as it is the database administrator password for the database cluster and will be required later.

 

Step 2: Download PostgreSQL client files

Tip: Client Files (use only 32 bit because ArcMap desktop is a 32 bit application)

 

Step 3: Copy and Paste the PostgreSQL client libraries/files in your ArcGIS Desktop Folder.

List of client files required:

  • libeay32.dll
  • libiconv-2.dll
  • libintl.dll
  • libpq.dll
  • ssleay32.dll

Copy and paste these client files to: C:\Program Files (x86)\ArcGIS\Desktop(version)\bin

 

Step 4: Copy and paste the ST_Geometry.dll libraries in the PostgreSQL lib directory.

For creating a geodatabase, st_geometry.dll file is required. It should be correctly placed in PostgreSQL lib folder.

In windows explorer, navigate to the below location and copy st_geometry.dl file:

            C:\Program Files (x86)\ArcGIS\Desktop(version)\DatabaseSupport\PostgreSQL\Windows64

Now navigate to the below given location and paste the .dll file:

           C:\Program Files\ArcGIS\Desktop<release#>\DatabaseSupport\PostgreSQL\Windows64.

           e.g.: C:\Program Files\PostgreSQL\10\lib

 

Step5: Create Enterprise Geodatabase in ArcMap Desktop.

By using ‘Create Enterprise Geodatabase’ geoprocessing tool you can create Enterprise GDB, sde user and sde schema in PostgreSQL.

Tip: ESRI Guide for creating enterprise GDB, https://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/create-enterprise-geodatabase.htm