Relational Datastore Validation Error

Question

Hi Team,

I hope you all doing well!!

We are facing an issue related to ArcGIS relational datastore. The ArcGIS Data Store on hosting machine is currently non-functional. The internal PostgreSQL instance fails to start with the following error:

"Error encountered: No valid connection to ArcGIS Data Store configuration store established.
Caused by: Connection to localhost:9876 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections."

Log of the Database

2025-07-22 08:31:41 IST: [3960]: [104-1] CONTEXT: line 40 of configuration file "D:/arcgisdatastore/pgdata/pg_hba.conf"
2025-07-22 08:31:42 IST: [2388]: [1-1] LOG: database system was shut down in recovery at 2025-07-22 07:47:15 IST
2025-07-22 08:31:42 IST: [2388]: [2-1] LOG: invalid primary checkpoint record
2025-07-22 08:31:42 IST: [2388]: [3-1] PANIC: could not locate a valid checkpoint record
2025-07-22 08:31:43 IST: [3960]: [105-1] LOG: startup process (PID 2388) exited with exit code 255
2025-07-22 08:31:43 IST: [3960]: [106-1] LOG: aborting startup due to startup process failure
2025-07-22 08:31:43 IST: [3960]: [107-1] LOG: database system is shut down.

Could you please help me in resolving the issue.

Thanks & regards,

Kristofer

MortenMa93 · Answer

Hej @Kristofer

Sometimes the "E:\arcgisdatastore\pgdata\pg_hba.conf" file gets "corrupt". Some of the entries in that file, loses its entry on a new line, and get stuck behind another entry.

So you have to put that entry back in its correct place and save the pg_hba file. Then restart your ArcGIS Datastore service.

ArcgisDatastore.PNG

Todd_Metzler · Answer

Hello, @HarryPlendl 's suggestion is a good one.

Q#1: Is your deployment a base deployment on one compute resource?  Q#2: Do you have other components on other compute resources?  If yes to question #2, then you should reconfig your datastore connection to use FQDN instead of localhost.

Also, suggest checking with your organization user authentication tier admin and if a Windows Server, the organization group policy admin.  Depending on the "moving parts" in your IT enterprise, I've seen cases where a change to Windows server firewall settings on a local server hosting the ArcGIS datastore are nullified when the group policy in the domain is updated which is usually a periodic event set by the group policy admin or re-read at server reboot.  If Linux host, check the firewall settings allign with the account designated to run the datastore service.

Running these datastore utilities once you've verified you can connect is sometimes helpful too.

1. describedatastore

2. unregisterdatastore

3. replacesslcertificate (it's a connection problem.  Is your SSL cert chain current?)

4. registerdatastore

HarryPlendl · Answer

D: /arcgisdatastore/pgdata/pg_hba.conf <---- This makes me think about the list of approved IPs on the machine.

I just went through a similar error. Added a new firewall inbound/outbound rule for the 9876

Case- Unable to validate federation for Portal for ArcGIS 10.9.1
 
Case Effective Resolution-

* Navigated to Portal home> Organization> Settings> Server and received the error "Failed to validate server managed database" while trying to validate the federation.
* Navigated to Server manager> Site> Datastores, tried validating the relational datastore however, it failed.
* Checked the server logs and found the error "The connection property set was missing a required property".
* We then opened the Windows Defender Firewall> Advanced Settings and added the inbound and outbound rules for port 9876.
* We were then able to validate the relational datastore as well as the federation successfully.

You can refer to the following document for your future reference-

* Ports used by ArcGIS Data Store

Shout out to Krutika from Esri Support Services.

I hope this help you resolve your error.