How to set up a PostgreSQL database in Django

Question

I m new to Python and Django   I m configuring a Django project using a PostgreSQL database engine backend  But I m getting errors on each database operation  For example when I run manage py syncdb  I m getting   C  xampp htdocs djangodir gt python manage py syncdb Traceback  most recent call last     File  manage py   line 11  in  lt module gt      execute manager settings    File  C  Python27 lib site-packages django core management   init   py   line 438  in execute manager     utility execute     File  C  Python27 lib site-packages django core management   init   py   line 379  in execute     self fetch command subcommand  run from argv self argv    File  C  Python27 lib site-packages django core management   init   py   line 261  in fetch command     klass   load command class app name  subcommand    File  C  Python27 lib site-packages django core management   init   py   line 67  in load command class     module   import module   s management commands  s     app name  name     File  C  Python27 lib site-packages django utils importlib py   line 35  in im port module       import   name    File  C  Python27 lib site-packages django core management commands syncdb py    line 7  in  lt module gt      from django core management sql import custom sql for model  emit post sync  signal   File  C  Python27 lib site-packages django core management sql py   line 6  in   lt module gt      from django db import models   File  C  Python27 lib site-packages django db   init   py   line 77  in  lt modul e gt      connection   connections DEFAULT DB ALIAS    File  C  Python27 lib site-packages django db utils py   line 92  in   getitem        backend   load backend db  ENGINE      File  C  Python27 lib site-packages django db utils py   line 33  in load back end     return import module   base   backend name    File  C  Python27 lib site-packages django utils importlib py   line 35  in im port module       import   name    File  C  Python27 lib site-packages django db backends postgresql base py   li ne 23  in  lt module gt      raise ImproperlyConfigured  Error loading psycopg module   s    e  django core exceptions ImproperlyConfigured  Error loading psycopg module  No mo dule named psycopg   Can someone give me a clue on what is going on

User · Accepted Answer

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

User · Answer

This may seem a bit lengthy  but it worked for me without any error   At first  Install phppgadmin from Ubuntu Software Center   Then run these steps in terminal   sudo apt-get install libpq-dev python-dev pip install psycopg2 sudo apt-get install postgresql postgresql-contrib phppgadmin   Start the apache server  sudo service apache2 start   Now run this too in terminal  to edit the apache file   sudo gedit  etc apache2 apache2 conf   Add the following line to the opened file   Include  etc apache2 conf d phppgadmin   Now reload apache  Use terminal   sudo  etc init d apache2 reload   Now you will have to create a new database  Login as  postgres  user  Continue in terminal   sudo su - postgres   In case you have trouble with the password of  postgres   you can change it using the answer here https   stackoverflow com a 12721020 1990793 and continue with the steps   Now create a database  createdb  lt db name gt    Now create a new user to login to phppgadmin later  providing a new password   createuser -P  lt new user gt    Now your postgressql has been setup  and you can go to   http   localhost phppgadmin    and login using the new user you ve created  in order to view the database

User · Answer

I was having the same Issue on Mac   The solution was to use only PIP to install everything  and touch some things   First install PIP from  https   pip pypa io en latest   Then you want to make sure if path to pg config is in your PATH  echo  PATH   if not you can edit your bash profile   vi  Users  lt user gt   bash profile   and add this line   export PATH  PATH  path to pg config bin   If you don t know where pg config is you can use the  locate  tool  but be sure your locate db is up to date  i was using an old locate db and using paths that does not exists    sudo  usr libexec locate updatedb locate pg config   Then install Django  if needed  and psycopg2   sudo pip install Django sudo pip install psycopg2   And then in settings py  localhost defaultport   DATABASES          default              ENGINE    django db backends postgresql psycopg2            NAME    dbname            USER    postgres            PASSWORD    postgres            HOST                PORT                 Greets

User · Answer

Step by step that I use    - sudo apt-get install python-dev  - sudo apt-get install postgresql-server-dev-9 1  - sudo apt-get install python-psycopg2 - Or sudo pip install psycopg2   You may want to install a graphic tool to manage your databases  for that you can do   sudo apt-get install postgresql pgadmin3    After  you must change Postgre user password  then do    - sudo su  - su postgres -c psql postgres  - ALTER USER postgres WITH PASSWORD  YourPassWordHere    -  q   On your settings py file you do   DATABASES          default              ENGINE    django db backends postgresql psycopg2            NAME    dbname            USER    postgres            PASSWORD    postgres            HOST                PORT                 Extra   If you want to create the db using the command line you can just do   - sudo su - su postgres -c psql postgres - CREATE DATABASE dbname  - CREATE USER djangouser WITH ENCRYPTED PASSWORD  myPasswordHere   - GRANT ALL PRIVILEGES ON DATABASE dbname TO djangouser    On your settings py file you do   DATABASES          default              ENGINE    django db backends postgresql psycopg2            NAME    dbname            USER    djangouser            PASSWORD    myPasswordHere            HOST                PORT

User · Answer

The immediate problem seems to be that you re missing the psycopg2 module

User · Answer

Also make sure you have the PostgreSQL development package installed  On Ubuntu you need to do something like this     sudo apt-get install libpq-dev

User · Answer

Please note that installation of psycopg2 via pip or setup py requires to have Visual Studio  2008  more precisely executable file vcvarsall bat   If you don t have admin rights to install it or set the appropriate PATH variable on Windows  you can download already compiled library from here

User · Answer

You can  install  psycopg  with the following command     sudo easy install psycopg2   Alternatively  you can use pip      pip install psycopg2   easy install and pip are included with ActivePython  or manually installed from the respective project sites   Or  simply get the pre-built Windows installer

User · Answer

sudo apt-get install libpq-dev   Year  this solve my problem  After execute this  do  pip install psycopg2

User · Answer

If you are using Fedora 20  Django 1 6 5  postgresql 9 3   and you need the psycopg2 module  do this   yum install postgresql-devel easy install psycopg2   If you are like me  you may have trouble finding the well documented libpq-dev rpm    The above worked for me just now

User · Answer

This is one of the very good and step by step process to set up PostgreSQL in ubuntu server  I have tried it with Ubuntu 16 04 and its working   https   www digitalocean com community tutorials how-to-use-postgresql-with-your-django-application-on-ubuntu-14-04

[python] How to set up a PostgreSQL database in Django

Installation

Configuration

Examples related to python

Examples related to django

Examples related to postgresql

Examples related to psycopg2

Examples related to django-settings