Not able to connect to my rds cluster using PG admin

0

I have created my RDS cluster using CFT.

This is the CFT which I used

{
    "AWSTemplateFormatVersion": "2010-09-09",
    "Description": "The template for aurora rds cluster.",
    "Parameters": {
      "tagName": {
        "Type": "String"
      },
      "subnetIds": {
        "Type": "CommaDelimitedList"
      }
    },
    "Resources": {
      "dbSubnetgroup": {
        "Type" : "AWS::RDS::DBSubnetGroup",
        "Properties" : {
            "DBSubnetGroupDescription": "DB subnet group of aurora",
            "SubnetIds" : {
              "Ref": "subnetIds"
            },
            "DBSubnetGroupName" : {
              "Fn::Sub": "${tagName}-subnetGroup"
            },
            "Tags" : [ {
              "Key" : "service",
              "Value" : {
                "Ref": "tagName"
              }
            } ]
          }
      },
      "rdsCluster": {
        "Type": "AWS::RDS::DBCluster",
        "Properties": {
          "MasterUsername": { "Ref": "dbUsername" },
          "MasterUserPassword": { "Ref": "dbPassword" },
          "DBClusterIdentifier": {
            "Fn::Sub": "${tagName}"
          },
          "Engine": "aurora-postgresql",
          "DBSubnetGroupName": {
            "Fn::Sub": "${tagName}-subnetGroup"
          },
          "EnableCloudwatchLogsExports": ["postgresql"],
          "EnableHttpEndpoint": true,
          "Port": 5432,
          "Tags" : [ {
            "Key" : "service",
            "Value" : {
              "Ref": "tagName"
            }
          } ]
        },
        "DependsOn": [
          "dbSubnetgroup"
        ]
      }
    },
    "Outputs": {
      "clusterEndpoint": {
        "Description": "The RDS Cluster endpoint",
        "Value": {
          "Fn::GetAtt": [
            "rdsCluster",
            "Endpoint.Address"
          ]
        }
      }
    }
  }

I am not able to connect with the PG admin, its giving timeout

is there any specific permission requirements?? Thank you in advance

1 Answer
0

Hello.

Is the PG admin running from outside the VPC and trying to connect?
In that case, you need to enable public access and set the subnet in the subnet group as a public subnet.
By the way, you cannot set public access with Aurora Serverless V1, so if you want to use public access, please select V2.

profile picture
EXPERT
answered 5 months ago
  • Yes, I am trying to connect from outside. Its already been set to publicly accessible and I have sed two private and two public subnet in the subnet group.

    I guess I need to add the (CIDR/IP - Inbound) rule, I tried adding in the security group but its not reflecting in the rds instance security console.

    Any idea?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions