How to set up a PostgreSQL database in Django

by

You need to install psycopg2 Python library.

Installation

Download http://initd.org/psycopg/, then install it under Python PATH

After downloading, easily extract the tarball and:

$ python setup.py install

Or if you wish, install it by either easy_install or pip.

(I prefer to use pip over easy_install for no reason.)

  • $ easy_install psycopg2
  • $ pip install psycopg2

Configuration

in settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'db_name',                      
        'USER': 'db_user',
        'PASSWORD': 'db_user_password',
        'HOST': '',
        'PORT': 'db_port_number',
    }
}

– Other installation instructions can be found at download page and install page.

More Related Contents:

  1. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  2. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  3. psycopg2: insert multiple rows with one query
  4. Parameterized queries with psycopg2 / Python DB-API and PostgreSQL
  5. Passing table name as a parameter in psycopg2
  6. ImproperlyConfigured: You must either define the environment variable DJANGO_SETTINGS_MODULE or call settings.configure() before accessing settings
  7. Django JSONField inside ArrayField
  8. Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
  9. django.db.utils.OperationalError Could not connect to server
  10. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  11. Django connection to postgres by docker-compose
  12. How to set-up a Django project with django-storages and Amazon S3, but with different folders for static files and media files?
  13. Psycopg2 image not found
  14. How do you join two tables on a foreign key field using django ORM?
  15. Create a Postgres database using python
  16. sqlite3.OperationalError: unable to open database file
  17. How to find pg_config path
  18. Django ConnectionAbortedError: [WinError 10053] An established connection was aborted by the software in your host machine
  19. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  20. Python/postgres/psycopg2: getting ID of row just inserted
  21. What is the default order of a list returned from a Django filter call?
  22. Escape SQL “LIKE” value for Postgres with psycopg2
  23. How to set connection timeout in SQLAlchemy
  24. How to quote a string value explicitly (Python DB API/Psycopg2)
  25. dynamically loading django apps at runtime
  26. Deploying Django to Heroku (Psycopg2 Error)
  27. Psycopg2, Postgresql, Python: Fastest way to bulk-insert
  28. Insert Python Dictionary using Psycopg2
  29. How Postgresql COPY TO STDIN With CSV do on conflic do update?
  30. How to solve “Page not found (404)” error in Django?

Leave a Comment