Deploying Django to Heroku (Psycopg2 Error)

by

EDITED:

As @mipadi has pointed out here (http://stackoverflow.com/questions/13001031/django-heroku-settings-injection/13092534), it can actually be as simple as this:

import dj_database_url

DATABASES = {'default' : dj_database_url.config() }

This works if you have a DATABASE_URL env variable set. heroku:pg_promote gets your there. Details below

Make sure you have Postgres on your Heroku 

heroku addons:add heroku-postgresql:dev

Step 1: figure out your database url

heroku config | grep POSTGRESQL

The output will look something like this:

HEROKU_POSTGRESQL__URL:
postgres://user:password@host:5432/blabla

Step 2: Grab the setting name from the previous step (e.g. HEROKU_POSTGRESQL_ROSE_URL) and put it in your settings file like so 

DATABASES = {'default': dj_database_url.config(default=os.environ["HEROKU_POSTGRESQL_ROSE_URL"])}

[UPDATE] As Ted has pointed out, there’s a way to promote the color URL to DATABASE_URL variable:

heroku pg:promote HEROKU_POSTGRESQL_ROSE_URL

Your database settings can then use DATABASE_URL as opposed to more exotic colored URLS 

DATABASES = {'default': dj_database_url.config(default=os.environ["DATABASE_URL"])}

Bob is your uncle

More Related Contents:

  1. No web processes running Django in heroku
  2. Collectstatic error while deploying Django app to Heroku
  3. How to manage local vs production settings in Django?
  4. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  5. H14 error in heroku – “no web processes running”
  6. Django JSONField inside ArrayField
  7. django.db.utils.OperationalError Could not connect to server
  8. Use Django ORM as standalone [duplicate]
  9. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  10. Django connection to postgres by docker-compose
  11. How to customize a requirements.txt for multiple environments?
  12. How to set up a PostgreSQL database in Django
  13. Composite primary key in django
  14. Can’t install psycopg2 with pip in virtualenv on Mac OS X 10.7
  15. How do you join two tables on a foreign key field using django ORM?
  16. Command not found: django-admin.py
  17. Heroku fails to install pywin32 library
  18. Case insensitive unique model fields in Django?
  19. Django JSONField filtering
  20. Docker- django throws error while connecting to postgres: psycopg2.OperationalError: could not connect to server: Connection refused
  21. How to find pg_config path
  22. Django staticfiles not found on Heroku (with whitenoise)
  23. Django ConnectionAbortedError: [WinError 10053] An established connection was aborted by the software in your host machine
  24. Heroku: ModuleNotFoundError :No module named ‘requests’
  25. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  26. What is the default order of a list returned from a Django filter call?
  27. django makemigrations and migrate on heroku server don’t create tables
  28. Django: sudden DB reset after Heroku sleep
  29. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  30. How to fix error “ERROR: Command errored out with exit status 1: python.” when trying to install django-heroku using pip [duplicate]

Leave a Comment