I am trying to connect to a database hosted on AMAZON EC2:
ec2-xx-xx-xxx-xxx.xxxx-1.amazonaws.com/companyName
I have been given the user and password for this.
What is the best way to connect to a database on this server?
I've tried this tool:
http://www.razorsql.com/register5.html
and also the postgres client to connect.
Thank you so much for your guidance/
Best Answer
It doesn't matter where you host the postgresql as long you or the admin opened the appropriate ports. So make sure that the ubuntu firewall is open for postgresql and the security group on amazon has the same port open too. Check this article about security group
Then you can use whichever client you prefer.