postgres: could not find the database system

Question

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?

RobStauder1 · Answer

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

Dan_Brumm · Answer

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