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개 답변
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
답변함 일 년 전
  • 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
답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠