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 Risposta
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
ESPERTO
con risposta 5 mesi fa
  • 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?

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande