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 Antwort
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
EXPERTE
beantwortet vor 5 Monaten
  • 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?

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen