Hook django up with postgresql using psycopg2

Question

I am trying to hook my website up to use postgresql. I installed postgresql and psycopg2. In settings.py, I placed the following, and then got the error shown afterwards. I should mention that I tested the site with mysql before attempting to migrate to postresql.

from Settings.py:

DATABASES = {

'default': {
    'ENGINE': 'django.db.backends.postgresql_psycopg2',
    'NAME': 'pdbt', 
    'USER': '',
    'PASSWORD': '',
    'HOST': 'localhost',
    'PORT': '', 
}
}

error:

DatabaseError at /viewer/

relation "django_session" does not exist

LINE 1: ...ession_data", "django_session"."expire_date" FROM "django_se...

did you run ./manage.py syncdb ?

karthikr
– karthikr

2013-06-21 14:54:01 +00:00
Commented Jun 21, 2013 at 14:54 — karthikr
– karthikr, Commented Jun 21, 2013 at 14:54

Ghasem · Accepted Answer · 2015-06-04 19:35:24Z

2

And if anyone is using newer versions of django, they should run this command:

//for newer versions
python manage.py migrate 

//for old versions
python manage.py syncdb

answered Jun 4, 2015 at 19:35

Ghasem

15.8k27 gold badges151 silver badges192 bronze badges

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

Comments

user2104778 · Accepted Answer · 2013-06-21 14:55:15Z

1

Ok I figured it out - I had to run syncdb! Yikes. Also, I see that karthikr pointed out the same thing. Thanks!

answered Jun 21, 2013 at 14:55

user2104778

1,0601 gold badge16 silver badges38 bronze badges

Comments

Will · Accepted Answer · 2014-06-02 00:37:04Z

1

If you see the above error message, it means you haven't created the tables yet. To create the tables, just do the following:

Switch to the directory that you have 'manage.py'
Then do 'python manage.py syncdb' and you'll see the following:

answered Jun 2, 2014 at 0:37

Will

11.5k9 gold badges71 silver badges77 bronze badges

Collectives™ on Stack Overflow

Hook django up with postgresql using psycopg2

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related