topic Using AWS CloudFormation - is there an ESRI template for PostGres? in Cloud Computing Questions

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

Anonymous User — Sat, 02 Sep 2017 04:14:19 GMT

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

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

BMoore — Tue, 24 Oct 2017 17:09:52 GMT

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

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

Anonymous User — Tue, 24 Oct 2017 19:26:31 GMT

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.

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

GLCAdmin — Thu, 16 Nov 2017 16:09:02 GMT

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?

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

Anonymous User — Sat, 18 Nov 2017 16:17:38 GMT

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.

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

JoshuaBixby — Sat, 18 Nov 2017 16:19:59 GMT

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