postgres: could not find the database system

[RobStauder]

Our Datastore suddenly stopped working this morning and wrote this error into the system error log:

postgres: could not find the database system Expected to find it in the directory "C:/arcgisdatastore/pgdata", but could not open file "C:/arcgisdatastore/pgdata/global/pg_control": No such file or directory

I was able to confirm that there is no pg_control file or folder in global.

describedatastore returns this - 

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.

I checked the firewall and 9876 is not open. This seems odd given that the site has been up for quite some time now.

Any ideas? Just open the port?

[Dan_Brumm]

Rob                               

 I have had this happen to me many times. Everything is working fine and then magically localhost:9876 refused.  This happens to systems I rarely touch more often than my Production system. 

For me, 95% of the time I reboot my host and it will come back online. The other 5% require a uninstall / reinstall.   I also have this trick where I make a change to the security settings of my ArcGIS Server (change https only to http/https) and save those changes and sometimes that will bring it back. 

I will say at 10.9.1 I have had better luck with my datastores. 

Dan                                                       

[RobStauder]

A friend of mine reminded me to add the version - 11.1.

We reverted to a previous snapshot. The site is now back up. 

Thanks for your input @Daniel