AWS RDS Postgresql Horizontal or Vertical Scaling

JoelMa · ‎05-09-2024

We have setup a highly available ArcGIS Server site in a DMZ network architecture using Esri's CloudFormation template on AWS, with a RDS Postgresql database. The ArcGIS Server instances are in an auto-scaling group where we can configure to scale in or out. But for the RDS, are there any issues with scaling the RDS horizontally or vertically, in terms of compatibility with ArcGIS Server?

Is it as easy as changing the RDS to a more powerful instance type??

MarceloMarques · ‎05-09-2024

@JoelMa - yes, you can scale up and down your RDS PostgreSQL Instance based on the workload.
Amazon RDS Features | Cloud Relational Database | Amazon Web Services

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |

View solution in original post

MarceloMarques · ‎05-09-2024

@JoelMa - yes, you can scale up and down your RDS PostgreSQL Instance based on the workload.
Amazon RDS Features | Cloud Relational Database | Amazon Web Services

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |

JoelMa · ‎05-10-2024

Thanks for confirming!