Esri / arcgis-cookbook

Chef cookbooks for ArcGIS
Apache License 2.0
290 stars 115 forks source link

arcgis-egdb deployment with RDS and HA Servers (10.9.1) #327

Open travisnburton opened 1 year ago

travisnburton commented 1 year ago

It's unclear how to deploy egdb on RDS for primary and secondary 'ArcGIS Server' instances.

cookbooks/arcgis-egdb#dependencies "...does not support creating databases in Amazon RDS..."

templates/arcgis-egdb/10.9.1#arcgis-egdb-rds-postgres "Creates a geodatabase 'egdb' in PostgreSQL on Amazon RDS..."

Assuming the arcgis-egdb-rds-postgres works to provision an RDS database, would i use the same template on both the primary and secondary 'ArcGIS Server' instances? (I would expect psql to fail on the secondary when trying to create a database that already exists.)

Thanks!

pbobov commented 1 year ago

arcgis-egdb-rds-postgres.json creates a geodatabase 'egdb' in PostgreSQL on Amazon RDS and registers it with ArcGIS Server. It must run only once on either primary or secondary ArcGIS Server instance.

If you run it more than once (or on different instances), it should just do nothing because Chef recipes are expected to be idempotent.