Amazon RDS PostgreSQL not accepting TCP connections on port 5432

Question

I have created a PostgreSQL Amazon RDS databaes but I cannot connect to it from my local machine.

I am connecting like this:

psql -h <db endpoint> -p 5432 -U <username> <db name>

Response is:

Is the server running on host and accepting TCP/IP connections on port 5432?

Here are the database settings:

RDS settings

Here are my security group settings:

Security group inbound rules

Pls. move the question to dba.stackexchange.com.

kometen
– kometen

2017-05-29 12:03:34 +00:00
Commented May 29, 2017 at 12:03 — kometen
– kometen, Commented May 29, 2017 at 12:03

John Rotenstein · Accepted Answer · 2017-05-29 12:13:00Z

15

Your configuration picture is showing a setting of Publicly Accessible = No.

You will need to modify your database to set this to Yes.

From Modifying a DB Instance Running the PostgreSQL Database Engine:

Publicly Accessible

Choose Yes to give the DB instance a public IP address, meaning that it will be accessible outside the VPC (the DB instance also needs to be in a public subnet in the VPC); otherwise, choose No, so the DB instance will only be accessible from inside the VPC.

answered May 29, 2017 at 12:13

John Rotenstein

273k28 gold badges456 silver badges541 bronze badges

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

1 Comment

Saurabh Bhatia Over a year ago

Thanks @John Rotenstein

Trang Pham · Accepted Answer · 2018-06-07 18:33:47Z

11

If you don't want to have Publicly Accessible = Yes then you should ensure that you've set a Security Group which has an Inbound rule. You'd have to then ensure that the security group is set up correctly.

answered Jun 7, 2018 at 18:33

Trang Pham

1811 silver badge5 bronze badges

3 Comments

Michael Hays Over a year ago

Thanks, it was the inbound rules on the security group for me!

Casey L Over a year ago

Thank you @Trang Pham! In my case I had cloned a CodePipeline but wanted its EC2 instance to connect to a new RDS database. I had forgotten to change the EC2 instance's Security Group to match the one containing the inbound rule on the new db. Hint - make sure you choose the security group listed under Source for the Inbound Rule, not the security group assigned to the RDS itself!

morsik Over a year ago

You should still have Publicly Accessible = Yes if you connect outside of VPC network. You still can use Security Group. Inbound rule to limit ingress connections

Collectives™ on Stack Overflow

Amazon RDS PostgreSQL not accepting TCP connections on port 5432

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related