cannot connect to a postgresql database instance

Question

I created a postgres database using standard create. I tried this -

nc -zv

using my endpoint and port number and it timed out.

endpoint was vcs.c2ayp2tfftm5.us-east-2.rds.amazonaws.com
port was 5432

Answer

This could be a number of things, start by verifying the security group that is associated with the RDS instance has port 5432/tcp opened for ingress from your IP address (just for troubleshooting you may want to broaden this to be open from 0.0.0.0/0).

Also, verify that the subnet that you have provisioned the database in is accessible from the internet. Amazon Reachability Analyser may be able to help you here https://aws.amazon.com/blogs/database/troubleshoot-network-connectivity-to-amazon-rds-databases-using-vpc-reachability-analyzer/

if you're still having trouble after all this, further things to try are listed in these docs https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Troubleshooting.html https://repost.aws/knowledge-center/rds-cannot-connect

cannot connect to a postgresql database instance

Relevant content