You can translate the question and the replies:

Connecting to Postgresql on EC2 Instance

Hi, I am trying to connect to a database "user" on a PostgresQL I set up on an EC2 instance. I believe I have allowed port 5432 on the inbound rules and I have modified the two config files. But I received this error message. Unable to establish connection: Connection to ec2-34-195-32-161.compute-1.amazonaws.com:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Would you please help me?
user
06-08-2020 19:50:43 -0400

2 Answers

Hi, The "*Connection to ec2-34-195-32-161.compute-1.amazonaws.com:5432 refused*" error would have occurred when the Virtual DataPort server is unable to reach the PostgreSQL in the EC2 instance. In order to resolve the issue, I would perform the following checks: * Check whether the server you’re connected to has started and running. * Check if you have a firewall that is blocking the port that you are trying to listen to. Additionally, in order to get more information about this error, I would check the **vdp.log** file which is located under the folder “**<DENODO_HOME>/logs**” Hope this helps!
Denodo Team
07-08-2020 04:00:19 -0400
Thanks! We figured it out. It was one of the config files need to open to all rather than localhost.
user
07-08-2020 11:59:40 -0400
You must sign in to add an answer. If you do not have an account, you can register here