How to set up PostgreSQL and connect Flask app's DB running on Heroku to the droplet?

April 22, 2015 1.1k views
Python PostgreSQL Python Frameworks

What I got so far:

1) I went through How To Install and Use PostgreSQL on Ubuntu 14.04
2) Edit postgresql.conf to have listen_addresses = '*'
3) Edit pg_hba.conf to have host all all md5

In my Flask app, which in running on Heroku, I config the DATABASE_URL to my droplet that is running the PostgreSQL 9.3: postgres://user:password@xxx.xxx.xxx.xxx:port/name

On the server, I run "netstat -plunt" to see a list of which ports are open:
tcp 0 0* LISTEN 12341/postgres

Where did I do wrong? How can I set it up so my Flask app can connect to the database?

1 Answer


Everything here looks good, have you restarted postgres with /etc/init.d/postgresql restart? Your netstat output suggests that it's still only listening on the local connection.

Also make sure when you set listen_addresses = '*' that you uncommented it (removed the # in front of it).

The # indicates that it's a comment and not read by the service. So you have to remove that so it's read by postgres.

Have another answer? Share your knowledge.