Using AWS CloudFormation - is there an ESRI template for PostGres?

[Anonymous User]

Hi.

I'm wanting to use AWS CloudFormation to build a single server deployment of ArcGIS Enterprise. The standard template available for Windows appears to install SQL Server 2016 as the database. I assume that AWS is charging the license for this.

I would rather be using PostGres. Does anyone know if there is a template available anywhere that would install a deployment with Windows and PostGres?

CloudFormation templates to deploy ArcGIS Enterprise on Amazon Web Services | ArcGIS Enterprise 

[BMoore]

I have the same question.  Did you end up getting PostGreSQL on Windows?

[Anonymous User · Accepted solution]

In the end I was told that the 'Windows' AWS CloudFormation template installs SQL Server Express (and not the fully licensed SQL Server Standard), therefore the answer is to use that template, then manually install PostGreSQL afterwards.

[GLCAdmin]

Hi Paul,

I am having the same question. Did you find any documentation about replacing SQL Server Express with PostgreSQL? How would this affect the Data Store? Do you just uninstall one and install the other? 

[Anonymous User]

Hi. I didn't uninstall SQL Server Express, if that's what you mean. I just installed PostgreSQL as well and used that. Installing Postgres doesn't affect Data Store as far as I'm aware, they co-exist side by side quite happily.

I followed the standard esri docs online about installing Postgres, I can't remember the links sorry, you'll have to search for them. I used the Postgres install files downloaded from MyEsri, but I think you can use the standard installation files if you wish, just pay attention to which Postgres version you install because I don't think the very latest one is 'officially' support by ESRI yet.

[JoshuaBixby]

A real Rube Goldberg on Esri's behalf, but thanks for sharing what you found out to make it work.