Connecting EC2 Amazon Linux2 to RDS PostgreSQL

Question

I have an EC2 Amazon Linux2 running, and I want to access to RDS PostgreSQL databse from EC2. I have finished adding EC2's security group ID to RDS's security group inbound. I also successfully connected to RDS from my local PC.

I was looking for a way (or cli command) to connect to RDS from EC2 Amazon Linux. Similary way for MySQL is:

sudo yum install mysql
mysql -u {username} -p -h {hostname}

I want to do the same with PostgreSQL, but could not find how to do so. If there's a way I can follow through, please let me know.

Thanks!

See: Installing PostgreSQL Client v10 on AWS Amazon Linux (EC2) AMI - Stack Overflow — John Rotenstein
– John Rotenstein, Commented Jan 23, 2022 at 22:27

s4ros · Accepted Answer · 2022-01-23 15:50:47Z

1

why don't you use docker for that?

The easiest and fastest way that comes into my head is to do something like that

First, install docker

$ curl -L get.docker.com | sudo bash
$ sudo usermod -a -G docker $(whoami)

... you need to logout & login!

Then run docker container

$ docker run --rm -it postgres psql -h [your_RDS_host] -U [username] -W [database_name]

And you should be fine 😊

answered Jan 23, 2022 at 15:50

s4ros

243 bronze badges

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

Collectives™ on Stack Overflow

Connecting EC2 Amazon Linux2 to RDS PostgreSQL

1 Answer 1

First, install docker

Then run docker container

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

First, install docker

Then run docker container

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related