HA CloudFormation Failure

Overview

This article goes over how to get past the SFTP Gateway CloudFormation template failure for HA deployments.

The Issue

When you deploy a High Availability CloudFormation stack of SFTP Gateway 3.4.6 and other versions using postgres 13.7, you will be met with a failure to create the SftpgwDB resulting in a deployment failure and rollback.

This is due to AWS deprecating version 13.7 of postgres.

Resolution

To fix the issue, you will need to edit the CloudFormation template and change the version of postgres, so that it now points towards 13.9 instead of 13.7.

In your SFTP Gateway CloudFormation stack, navigate to the Template tab.

Click View in Designer.

This will allow you to view & edit the CloudFormation template in AWS CloudFormation Designer.

Scroll down to line 380 and you will view the database for SFTP Gateway, which is currently Postgres 13.7.

However, due to the deprecation of Postgres 13.7, we will need to use another version. So, on line 389, change the EngineVersion to 13.9 instead.

Once you've made your change, in the top left, click on the cloud icon with an arrow in it which reads Create stack. After specifying the stack details, this will create a new SFTP Gateway stack using a working database version.