I am running a postgres db cluster on aws and I’d like to allow an ec2 instance to make programmatic changes to the database. When I try to run the program I get the following error:

"botocore.errorfactory.HttpEndpointNotEnabledException: An error occurred (HttpEndpointNotEnabledException) when calling the ExecuteStatement operation: HttpEndpoint is not enabled for resource arn:aws:rds:xxxx:xxxx:cluster:xxxx." 

However, when I try to enable HttpEndpoint through the aws cli on the ec2 instance with the command:

aws rds modify-db-cluster --db-cluster-identifier db-xxxx --enable-http-endpoint

The flag is left unchanged. I also tried using the –apply-immediately flag, though the docs say this shouldn’t matter. How do I enable an HttpEndpoint on a postgres 16.3 db cluster running on aws?

On an ec2 instance connected to the postgres cluster:

$ aws rds modify-db-cluster --db-cluster-identifier db-xxxx --enable-http-endpoint

and

$ aws rds modify-db-cluster --db-cluster-identifier db-xxxx --enable-http-endpoint --apply-immediately

both give the same response:

{
    "DBCluster: {
        "AllocatedStorage": xxxx,
        "DBClusterIdentifier": "db-xxxxx",
        ...
        "HttpEndpointEnabled: false,
        ...
}

I was expecting the response to have changed the HttpEndpointEnabled value to true:

{
    "DBCluster: {
        "AllocatedStorage": xxxx,
        "DBClusterIdentifier": "db-xxxxx",
        ...
        "HttpEndpointEnabled: true,
        ...
}