Remote postgres database on Heroku app

Question

How can i connect my Heroku app to a Postgres database hosted on amazon EC2 without any paid addon? I am using Django and my current code is:

DATABASES = {'default': dj_database_url.config(default='postgres://postgres:xxx@publicip/dbname')}

but i am still getting connected to my local database instead..

For some platforms Heroku seems to override the usual connection configuration and inject its own config. You may need to look up Heroku-specific documentation on Django to see how it configures connections in Django. — Craig Ringer
– Craig Ringer, Commented Jun 6, 2014 at 0:53

catsby · Accepted Answer · 2014-06-06 21:13:50Z

2

Your application is likely connecting to a free Postgres database as defined by the DATABASE_URL environment variable. You should use config:set to set that variable to point to your remote database, and ensure your code connects to that DATABASE_URL:

$ heroku config:set DATABASE_URL=postgres://postgres:xxx@publicip/dbname --app your_app

Collectives™ on Stack Overflow

Remote postgres database on Heroku app

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related