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.

posta un anno fa242 visualizzazioni
2 Risposte
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
MODERATORE
philaws
con risposta un anno fa
  • 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
con risposta un anno fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande