AWS RDS database instance needs to set max_connections and max_prepared_transactions

[AWSmith0216]

Terraform Version Details

1.10.5

Terraform Variable File Details

Not relevant

Steps to Reproduce

Create an RDS instance using the basic terraform input of:

postgres_servers = {
  default = {},
}

Expected Behavior

That the server parameters include the SAS documented requirements of max_connections and max_prepared_transactions both set to at least 1024. Refer to documentation:

https://helpcenter.unx.sas.com/test/doc/en/itopscdc/v_061/itopssr/p05lfgkwib3zxbn1t6nyihexp12n.htm#p1wq8ouke3c6ixn1la636df9oa1u

Actual Behavior

Neither are set to the SAS documented values. Parameter max_connections is set to:

LEAST({DBInstanceClassMemory/9531392},5000)

For an 8 GB DB instance I believe this comes out to a value of about 901. Parameter max_prepared_transactions is set to 0, and not in the good way (infinite).

Additional Context

No response

References

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

[AWSmith0216]

Note that the following terraform input yields what I believe to be the desired result:

postgres_servers = {
  default = {
    parameters = [
        { 
          "apply_method": "pending-reboot", 
          name: "max_connections",
          value: "1024" 
        },
        { 
          "apply_method": "pending-reboot", 
          name: "max_prepared_transactions",
          value: "1024" 
        }
    ]
  }
}

Unfortunately an apply_method of immediate cannot be used with these parameters as they are static, and terraform will error out if attempted.