Failed connection to postgres on EC2 only, works on local machine

Question

I'm running an application on an EC2 instance (AWS cloud computing solution) that connects to a specific Database address.

When I run the application in my local machine it connects perfectly to the DB.

However, when I run it in the EC2 the connection hangs indefinitely. I've also tried to connect using psql to prove that the error was on the connection and received the "Connection timed out error".

Both my local machine and the EC2 instance are running ubuntu 22.04.

Does anyone have any idea what could be going on?

Where is the database hosted? What is the Outbound Security Group configuration on the EC2 instance? — John Rotenstein
– John Rotenstein, Commented Jul 28, 2022 at 6:05
Outbound rules are set to allow all. Inbound traffic is only allowed through SSH in port 22 over TCP — João A. Veiga
– João A. Veiga, Commented Jul 28, 2022 at 9:58
Also worth mentioning that connection to other RDS services are completed correctly, the problem is with a specific RDS instance in the same VPC as the EC2 instance — João A. Veiga
– João A. Veiga, Commented Jul 28, 2022 at 10:11

Hùng Nguyễn · Accepted Answer · 2022-07-29 02:27:21Z

1

Both RDS instance and EC2 instance need to be in the same VPC, check your inbound rule of security group of your RDS. It must allow security group of your EC2 instance.

If you configured it to connect through public internet (not recommended) like what you did from local, the inbound rule of RDS need to allow IP of your EC2 instance.

edited Jul 29, 2022 at 2:27

answered Jul 28, 2022 at 10:12

Hùng Nguyễn

6391 gold badge10 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Failed connection to postgres on EC2 only, works on local machine

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related