Permanently Deleting Content in ArcGIS Data Store

[RyanUthoff]

Is there a way to permanently delete data from the ArcGIS Data Store? I notice when I delete a large amount of data through ArcGIS Pro from a hosted feature service (GB's worth of data being deleted), it doesn't actually delete the data from the server hosting the ArcGIS Data Store.

I have a limited amount of storage space on the server, and I need to be able to permanently delete the data, but it doesn't appear to delete it. It deletes it from the hosted feature service when viewing it through ArcGIS Pro or through Portal, but it doesn't actually free up any space. In addition, the daily data store backups continue to get larger even after deleting GB's worth of data.

Are there any solutions to this?

[JonathanQuinn]

The data should be deleted from the Data Store automatically when deleting a hosted feature service that uses that data. I imagine that the backups are taking up most of the space? If you run something like WinDirStat, can you determine which directory is consuming most of the space? You may need to update the retention policy of the Data Store to delete the backups quicker.

[RyanUthoff]

I'm sorry, I completely forgot that I posted this. Deleting the actual hosted feature service itself will delete the data.

But I don't want to delete an entire feature service just to delete the data, because then I'll just have to re-create it. Deleting records through the hosted feature service through ArcGIS Pro only deletes it from our view in Pro/Portal, but it doesn't actually delete any content because the space available never increases (this is after deleting thousands of records with thousands of picture attachments).

I did ask this question at the UC and the solution was to disable and re-enable sync in the hosted feature service settings in Portal. While that did work.....it also wrecked the feature service (from a Survey123 form). That solution might work on basic feature services, but I have some more complicated ones with related tables/attachments.

I'm not having an issue with backups as they are getting stored on our file share and not on the VM itself.

[RyanUthoff]

Are there are any solutions to this? Is there any way we can connect to the ArcGIS Data Store and compress it? Deleting a hosted feature service and re-creating it is not an acceptable solution just to free up space.

[JustinO_Brien]

This is a major issue for us, and just adding more storage as our database grows isn't an option. You'd think that if ESRI is locking us into using their datastore to manage web services and content that we would be provided with tools to do basic database maintenance and admin tasks.

[drunneals_cgs]

You can connect to it with pg admin.

https://enterprise.arcgis.com/en/data-store/latest/install/windows/data-store-utility-reference.htm

You can run the listadminusers or listmanageduser command to get the credentials for the admin/managed user.

The ds_* will be your server/instance. The db_* is your database.

Note this isn't supported by esri, so use at your own risk, but it should get you to where you need to be.