topic Re: postgres: could not find the database system in ArcGIS Enterprise Questions

postgres: could not find the database system

RobStauder — Tue, 12 Sep 2023 18:26:13 GMT

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?

Re: postgres: could not find the database system

Dan_Brumm — Tue, 12 Sep 2023 21:53:34 GMT

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

Re: postgres: could not find the database system

RobStauder — Fri, 15 Sep 2023 20:02:07 GMT

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