Postgres FATAL database does not exist Django

Question

I have seen many of these questions asked for Ruby but not for DJango. We have a postgres DB and created a table name Adam with our postgres user. When you psql -l the table shows up. However, when trying to run a migrate we get an error.

FATAL:  database "/var/lib/pgsql/9.3/data/Adam" does not exist

The psql -l shows this:

Name       |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------------+----------+----------+-------------+-------------+-----------------------
 Adam      | postgres     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

Django settings.py looks like..

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': os.path.join('/var/lib/pgsql/9.3/data/', 'Adam'),
        'USER': 'postgres',
        'PASSWORD': 'correctlyTypePassword'
    }
}

Any ideas why it thinks this doesn't exist?

Milen A. Radev · Accepted Answer · 2014-04-10 04:53:45Z

8

Your database settings are wrong. The key "Name" should refer to the database name not its path. Try this:

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.postgresql_psycopg2',
    'NAME': 'Adam',
    'USER': 'postgres',
    'PASSWORD': 'correctlyTypePassword'
    }
}

edited Apr 10, 2014 at 4:53

Milen A. Radev

63.1k22 gold badges111 silver badges112 bronze badges

answered Apr 9, 2014 at 23:42

yorodm

4,48126 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Postgres FATAL database does not exist Django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related