AWS Connecting to Postgres Not Working

Question

I am very new to AWS/Elastic Beanstalk/RDS but I can't figure out why I am unable to connect to my Postgres DB via Postico.

As far as I can tell, I am entering the correct credentials found under "Environment Properties" in the AWS dashboard.

When I run psql statements from the terminal (ssh'd in here as "ec2-user@ip-*****") it says "command not found". But my site is actually up and working. And according to the RDS tab on AWS it is definitely using Postgres.

When I try and connect using Postico (not via SSH), it just hangs for ages and then times out. No error! I'm using the same user, password, and host names stored in the "Environment Properties". I'm even using port 5432.

What can I try?

Vorsprung · Accepted Answer · 2016-02-24 14:24:28Z

4

Go to the RDS Dashboard
select 'DB Instances'
click the toggle in the LH column under "filter" next to database you wish to attach to
Copy the "Endpoint" setting ie postgres-db.ba2syxhcyfxx.eu-west-1.rds.amazonaws.com:5678
on your EC2 shell as root issue command yum install postgresql
in your shell on an EC2 issue command psql -h postgres-db.ba2syxhcyfxx.eu-west-1.rds.amazonaws.com -p 5678 -U myuser

Where "myuser" is the user you wish to attach as

edited Feb 24, 2016 at 14:24

answered Feb 24, 2016 at 14:09

Vorsprung

34.9k5 gold badges44 silver badges71 bronze badges

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

3 Comments

Vorsprung Over a year ago

added step to answer for installing postgresql client software. Hopefully yum is set up...

HereAndBeyond Over a year ago

If you receive errors like: No match for argument: postgresql10 or No match for argument: postgresql14 while running sudo yum install -y postgresql<your_version>. Just check what versions persist in repositories using sudo yum search "postgres". In my case there were neither postgresql10 nor postgresql14, but was postgresql15. So I invoked sudo yum install postgresql15 and it worked.

Vorsprung Over a year ago

@HereAndBeyond yes, and the same thing applies for postgresql clients on Ubuntu

Collectives™ on Stack Overflow

AWS Connecting to Postgres Not Working

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related