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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南