Deploying Django app's local postgres database to heroku?

Question

I am unsuccesfully getting my django app deployed on heroku to use my local postgres db.

My DATABASE settings are as follows:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'mydb',
        'USER': 'foo',
        'PASSWORD': 'bar',
        'HOST': 'localhost',
        'PORT': '',
    }
}

Everything runs fine locally. Following the instructions from https://devcenter.heroku.com/articles/django, I add the following bit a code to the bottom of my settings file:

import dj_database_url
DATABASES = {'default': dj_database_url.config(default='postgres://foo:bar@localhost/mydb')}
SECURE_PROXY_SSL_HEADER = ('HTTP_X_FORWARDED_PROTO', 'https')

However, this produces the following error:

OperationalError at / could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

My django app runs fine on Heroku, except when it needs to connect to the database, which is where it throws this error.

Anyone know what I am doing wrong here?

Your local db must be accessible from the Internet. If it's not, then you cannot use it on heroku. — spirit walker
– spirit walker, Commented Jul 22, 2013 at 0:39

Yuval Adam · Accepted Answer · 2013-07-22 07:39:29Z

1

Simply put, your current configuration defines the database host as localhost while you should be pointing it at your hosts public IP (or fully qualified domain name).

But this seems like an anti-pattern. You really should be using Heroku's development databases for this stuff, and if you have any local data you'd like to import there, just make a database dump and load it.

answered Jul 22, 2013 at 7:39

Yuval Adam

166k95 gold badges318 silver badges406 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

spirit walker · Accepted Answer · 2013-07-22 00:51:40Z

0

Allow remote postgres access to your local db. example
Change the settings file to something like this:

DATABASES = {

  'default': {
      'ENGINE': 'django.db.backends.postgresql_psycopg2',
      'NAME': 'your db name',
      'USER': 'your username',
      'PASSWORD': 'password',
      'HOST': 'Your computer's IP',
      'PORT': '6122',
  }

Or you have to clone your local db to heroku postgres and change your settings to use that db.

edited Jul 22, 2013 at 0:51

answered Jul 22, 2013 at 0:45

spirit walker

3041 silver badge6 bronze badges

1 Comment

rocket_raccoon Over a year ago

Thanks! I've decided to just use the heroku postgres db and everything works.

Collectives™ on Stack Overflow

Deploying Django app's local postgres database to heroku?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related