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

April 22, 2015 3.9k views
PostgreSQL Python Python Frameworks
ricek
By:
ricek

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 0.0.0.0/0 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 127.0.0.1:5432 0.0.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?

Log In to Comment
1 Answer
JamesMC June 24, 2016

Hello,

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.

Reply
Have another answer? Share your knowledge.

Related