InvalidParameterValue error when creating an instance for Service Broker for AWS Postgres Plan with SSL enabled

Products

• VMware Tanzu Application Service for VMs

Issue/Introduction

When SSL is enabled for a plan using Postgres, provisioning fails due to the creation of custom DB Parameter Group failings:

Server error, status code: 502, error code: 10001, message: Service broker error: InvalidParameterValue: ParameterGroupFamily postgres13.2 is not a valid parameter group family

This is due to the generation of ParameterGroupFamily with the format <engine><major>.<minor>, but instead AWS is expecting the format of Postgres <major> without <.minor>.

This only occurs when SSL is enabled because we take the following steps when provisioning is requested:
 

• Create a new DB Parameter Group
• Modify the `rds.force_ssl` flag to be 1

Resolution

In the AWS console, create a custom DB Parameter Group and modify the `rds.force_ssl` flag to equal 1. In the tile Postgres plan configuration, input the name of the custom DB Parameter Group in the `DB Parameter Group Name` field.