When attempting to validate ArcGIS Data Store, the validation process fails, and postgres.exe processes do not start on the ArcGIS Data Store machine. Running the describedatastore utility to determine the issue returns the following error message:
Error: Error encountered: No valid connection to configuration store established.. Extended error message: Connection to localhost:9876 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
Windows Event Viewer may display the following error message:
Error: FATAL: could not remove old lock file "postmaster.pid": Permission denied HINT: The file seems accidentally left over, but it could not be removed. Please remove the file by hand and try again.
Warning: Do not manually remove the postmaster.pid file. Removing the file may cause irreversible data corruption.
The postmaster.pid file utilized by ArcGIS Data Store cannot be read or modified by the ArcGIS Data Store Windows service account.
ArcGIS Data Store's underlying PostgreSQL database utilizes the postmaster.pid file to store PostgreSQL server process IDs. This file is located in C:\arcgisdatastore\pgdata. When ArcGIS Data Store crashes or is restarted unexpectedly, this directory may contain an old .pid file, preventing PostgreSQL from executing properly.
This issue is normally resolved automatically by the ArcGIS Data Store Windows service account. However, PostgreSQL and ArcGIS Data Store cannot start if the service account does not have sufficient permissions to modify or delete the old .pid file.
Note: The following workaround may require the assistance of the organization's IT department.
Ensure the ArcGIS Data Store Windows service account has the necessary permissions to access the following directories on the ArcGIS Data Store machine:
For more information on how to assign permissions to a Windows service account, refer to Error: The ArcGIS Server is not able to connect to the specified directory.