Managing ArcGIS Datastore

Question

I have ArcGIS Datastore and

1. I want to know how to monitor its health. I need to be able to tell when it's running normally or not.

2. I want to know how much data is stored in it and where.

3. I want to be able to manage backups for it.

4. I can see it has its own log files but I don't see how I am supposed to access them.

This snippet of code dumps out information, but that's about all I've come up with so far.

import arcgis.gis.server
from config import Config

server = arcgis.gis.server.Server(url = Config.SERVER_URL + '/admin',
    username = Config.PORTAL_USER, password = Config.PORTAL_PASSWORD
)
dsm = arcgis.gis.server.DataStoreManager(url = server.url + "/data", gis = server)
for ds in dsm.list():
    print(ds.properties)
    print()

cjms · Answer

If you're referring to the relational datastore that ArcGIS manages for you, this worked for me with PgAdmin. * Remote into server with the Postgres Data Store * Open command prompt * CD your way into the C:\Program Files\ArcGIS\DataStore ools folder * Run "listmanageduser.bat" * Write down the username, password, and database * Run "allowconnection.bat "* example: "C:\Program Files\ArcGIS\DataStore ools>allowconnection.bat 12345 user" * This will alter the pg_hba.conf file. You can open it to see your changes * IP is the computer you are using, not the server that has the datastore * Open PgAdmin --> register new connection * Enter username, password, and database from step 5 * Enter host name of the server with the datastore installed * Port is likely 9876* Run 'netstat -ano' and search for the PID corresponding with the PID of postgres.exe in Task Manger * Save connection Tables will be listed under the Schema --> username --> Tables

Brian_Wilson · Answer

I just had a phone conversation with Esri support and confirmed there's no other official documentation outside of https://enterprise.arcgis.com/en/portal/latest/administer/windows/what-is-arcgis-data-store.htm

If I needed to store other data, for example PostGIS tables, I'd put that in a separate PostgreSQL instance.

Currently we don't use the scene storage (aka "tile cache") which is just files so I can ignore that part entirely. That means this really just becomes a PostgreSQL project. I don't need to write anything so I can't see any harm in creating a read-only connection to monitor the database status.

The support tech directed me to the "describedatastore" command, for anyone else reading this you'd find that in "C:\Program Files\ArcGIS\Datastore	ools as a .BAT script. Running it will give config information and also a few status items. I don't really want to remote into the machine and parse the file. It works by running a java binary so it's not possible to dump that out and see what it's doing.

The firewall information page https://enterprise.arcgis.com/en/data-store/latest/install/windows/ports-used-by-arcgis-data-store.htm tells me that PostgreSQL is running on port 9876.

The script "listadminusers" gives the usernames and passwords to access the PostgreSQL server.

With this information I should be able to set up a pgadmin instance to look at the database and to create a 'read-only' account for monitoring it.

I still don't know how I am supposed access logs but I can see the files in C:/arcgisdatastore/logs so I will just read them as files.

ryanuthoff · Answer

All of your hosted feature services you published are in there as tables/views. So, if you publish a parcel table as a hosted feature service, that will show up as a table in the ArcGIS Data Store in the PostgreSQL database.

With that being said, you can't just go in and create/delete tables (well, you could, but Esri wouldn't recognize them). All of the interactions you do with the tables needs to be through Esri. Although, editing data directly through the DB should be fine, in theory. Doing anything with the data store outside of Esri is still a risk though.