[GIS] Connection property set error on registering PostgreSQL geodatabase with ArcGIS for Server

arcgis-10.2arcgis-serveresri-geodatabaselinuxpostgresql

We're in the middle of a migrating process.

We've imported a geodatabase on a new Linux machine and we're trying to publish some map services to this new ArcGIS Server (that resides on the same machine).

We've upgraded the 10.1 geodatabase to a 10.2 one.

The geodatabase was imported via pgAdmin backup- restore procedure then we used the Upgrade Geodatabase tool from ArcToolbox to go to 10.2.

We've encountered problems when trying to register the geodatabase with the server.
The error we get is:

The connection property set was missing a required property or the
property value was unrecognized. This release of the GeoDatabase is
either invalid or out of date. DBMS table not found

enter image description here

Same error occurs with a new created geodatabase as well.

Details:

  • ArcGIS Server 10.2 on a Linux Machine
  • PostgreSQL Geodatabase 9.2 on the same Linux Machine

Best Answer

You probably need to change the pg_hba.conf file to enable for remote connections.
Then you need to register the db with ArcGIS server.
In ArcGIS server you will go to the Site tab, and choose datastore.
Copy your sde connection file to the sever
and point to that connection file.
enter image description here
enter image description here

Related Question