Cannot connect to RDS Postgres

Question

I have setup a Postgres RDS Instance in EU Ireland. I have kept all outbound traffic as 0.0.0.0/0 and inbound traffic as :-

Type        Protocol        Port Range   Source   Description
PostgreSQL    TCP              5432     0.0.0.0/0

When I try to connect to RDS from my mac terminal I get this error -

psql --host=test.XXXXX.eu-west-1.rds.amazonaws.com --port=5432 --username=testuser --password --dbname=testdb
Password: 
psql: could not connect to server: Operation timed out
    Is the server running on host "test.XXXXX.eu-west-1.rds.amazonaws.com" (34.255.150.234) and accepting
    TCP/IP connections on port 5432?

I am based in Frankfurt but I am deploying the server in Ireland because I want to use AWS QuickSight which is not available in Frankfurt for now.

My OS Firewall is off as well. Public access is set to YES.

What am I doing wrong ?

Sergey Kovalev · Accepted Answer · 2019-06-16 08:50:47Z

2

Most likely, you didn't allow public access when you were creating your RDS instance. Change RDS instance properties to enable public access.

answered Jun 16, 2019 at 8:50

Sergey Kovalev

9,4712 gold badges30 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sergey Kovalev Over a year ago

Then it's likely that you've created your RDS instance in a VPC that doesn't have outside connectivity. Check the route table and internet gateway for this VPC.

Collectives™ on Stack Overflow

Cannot connect to RDS Postgres

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related