Search code examples
djangopostgresqlpgadminamazon-aurora

Unable to connect to Amazon Aurora with PgAdmin

I created an Amazon Aurora Postgres DB on my AWS account, and am now trying to connect to it using PgAdmin. I enter in the db name, username, password, and host, and port. When I try to connect I get this issue.

Unable to connect to server:

could not connect to server: Operation timed out
Is the server running on host "host_name.us-east-2.rds.amazonaws.com" (IP Address) and accepting
TCP/IP connections on port 5432?

I'm new to Amazon Aurora, and am not sure what my next step has to be to connect. I read the documentation, but can't find what I'm looking for. I'm also getting the same error when I try to connect to it with my production server that houses my Django application.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'dbname',
        'USER': 'username',
        'PASSWORD': 'password',
        'HOST': 'hostname.us-east-2.rds.amazonaws.com',
        'PORT': '5432'
    }
}

And I'm getting a similar issue

django.db.utils.OperationalError: could not connect to server: Connection timed out
        Is the server running on host "hostname.us-east-2.rds.amazonaws.com" (IP Address) and accepting
        TCP/IP connections on port 5432?
Solution

  • You should add the IP you are trying to connect from under Security Groups in EC2 to your RDS' security group as incoming mysql connection