Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to connect to a database hosted on AMAZON EC2:

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:

and also the postgres client to connect.

Thank you so much for your guidance/

share|improve this question
What is the problem you are experiencing ? – golja Aug 22 '12 at 23:21
the problem is i don't understand how to connect to EC2? can i just use a regular db client ? – l--''''''---------'''''''''''' Aug 22 '12 at 23:23
i know that they are running ubuntu – l--''''''---------'''''''''''' Aug 22 '12 at 23:24
@golja please let me know how i can help you help me. – l--''''''---------'''''''''''' Aug 22 '12 at 23:36
up vote 3 down vote accepted

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.

share|improve this answer
thanks so much for that article. i know that other people in other locations are able to connect, but i am not. i have forwarded that link to them and perhaps they just need to allow my IP in there – l--''''''---------'''''''''''' Aug 22 '12 at 23:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.