psql client not connecting and not giving any feedback.

0

I created a postgres database instance and to connect to it from my terminal, I followed this formula:

psql -h <REMOTE HOST> -U <DB_USER> <DB_NAME>

I inserted my specific info and pressed enter but nothing happened. I got no prompt, error or feedback.

2 Answers
1

You might check that you have network access from your terminal to the RDS resource. You can install this handy utility to determine if you can access your RDS database from your terminal

https://code.google.com/archive/p/paping/

./paping <REMOTE HOST> -p <PORT>

AWS
MODERATOR
philaws
answered a year ago
  • I downloaded it but when I try to open it I get "“paping” cannot be opened because it is from an unidentified developer."

0

Hi,

If I assume the database is not production yet, s

And if you want to access from your EC2 terminal, you can try to setup your database to be connected from EC2 easily by clicking this option "Connect to an EC2 compute resource" under "connectivity"

Enter image description here.

If you want to connect from your local computer:

a. Without VPN:

  • set RDS public accessible to "Yes"
  • set security group to allow inbound traffic from your local public IP address

But highly recommended you setup client-vpn, software-base vpn such OpenVPN , so you can put your databse still in private network which more secure then put it on public subnet.

profile pictureAWS
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions