Using a hosted AWS database such as Aurora in place of a big on-board PostGres database

JonathanEpstein — Fri, 21 Jul 2023 16:53:56 GMT

Hi,

We currently have a fairly large (1TB) on-board PostGres database in our 10.9.1 (Linux) Enterprise environment. Our ArcGIS Datastore EC2 instance seems to be right-sized for our requirements, and is an AWS r5.xlarge, i.e. 4CPUs and 32GB of RAM.

We have started to experiment a bit with Enterprise DB Connection to Aurora. But it's unclear to us whether this would replace our existing Datastore host? Or alternatively, would we still run a small ArcGIS Datastore host, whose role would be to broker communication with the Aurora database?

Thanks.

Re: Using a hosted AWS database such as Aurora in place of a big on-board PostGres database

George_Thompson — Mon, 24 Jul 2023 11:52:30 GMT

If I understand your question correctly, using Aurora would NOT replace your ArcGIS Datastore machine in the Enterprise deployment.

The ArcGIS Datastore is an ArcGIS Managed datastore. Aurora is a user-managed datastore. If you are wanting to use hosted services then you need to use the datastore. If you need advanced geodatabase functionality and features then you would need to use an Enterprise Geodatabase (in this case on Aurora) and register it with your ArcGIS Enterprise site.

You can use both in your deployment based on the need of the data and your workflows.

Here is a great white paper that discusses this: https://www.esri.com/content/dam/esrisites/en-us/media/technical-papers/data-in-arcgis-user-managed-and-arcgis-managed.pdf

Let us know if you have any other questions. Thanks!

topic Re: Using a hosted AWS database such as Aurora in place of a big on-board PostGres database in ArcGIS Enterprise Questions

Using a hosted AWS database such as Aurora in place of a big on-board PostGres database

Re: Using a hosted AWS database such as Aurora in place of a big on-board PostGres database