Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

I'm extremely new to cloud-computing, Linux, and PostgreSQL, so if this is a stupid question, I apologize.

I've managed to create an m1.large instance running Ubuntu 11.10, connect via Putty SSH, and install PostgreSQL (sudo apt-get install postgresql), but that is as far as I've gotten.

My goal is to run several python web-scraping scripts that I've written on this instance (so as not to eat up all of our bandwidth (smaller company at the moment)) and insert the scraped data into a PostgreSQL table on the instance and later retrieve that data to store on our local server (as I've heard AWS EBS is unreliable and I don't want to take chances).

How can I configure PostgreSQL on my AWS instance? How can I access the data from my machine? I currently use PgAdmin3 to manage PosgreSQL on our local server. Can I use this same interface to manage PostgreSQL on my AWS instance?

Any suggestions, solutions, links, etc is greatly appreciated. And again, if this is a dumb question, I apologize.

Thanks!

share|improve this question
add comment

closed as off topic by Blrfl, gnat, Robert Harvey, Walter, ChrisF Nov 8 '12 at 23:00

Questions on Programmers Stack Exchange are expected to relate to software development within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

up vote 2 down vote accepted

First, you need to open an inbound port(mentioned here) for postgresql on your EC2 instance. I am not an expert of postgresql but it should be 5432 if you are using defaults.

You may follow help.ubuntu's documentation to configure postgre, especially you need to make postgre listen to network in order to accept connections from internet via changing the related line in postgresql.conf to: listen_addresses = '*'. This entry would be useful

After these steps you may connect to your postgre via your usual PgAdmin3 by entering your public DNS address of your EC2 instance(something like "ec2-3-3-25-16.compute-1.amazonaws.com") as host address. Or you may use Elastic IP feature of AWS to assign a simpler IP address to your EC2 instance.

share|improve this answer
    
Thanks! I've got PostgreSQL properly configured. Its up and running, but when I try to connect with PgAdmin3, I receive an error stating the server doesn't listen. –  That1Guy Nov 7 '12 at 18:23
    
Oops! I forgot to uncomment listen_address in postgresql.conf Got it! –  That1Guy Nov 7 '12 at 18:33
add comment

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