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.

已提问 1 年前242 查看次数
2 回答
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
审核人员
philaws
已回答 1 年前
  • 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
已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则