Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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/

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 ? –  Yuck Aug 22 '12 at 23:23
    
i know that they are running ubuntu –  Yuck Aug 22 '12 at 23:24
    
@golja please let me know how i can help you help me. –  Yuck Aug 22 '12 at 23:36

1 Answer 1

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 –  Yuck Aug 22 '12 at 23:51

Your Answer

 
discard

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.