如何在 Django 中设置 PostgreSQL 数据库

问题描述

我是 Python 和 Django 的新手.

I'm new to Python and Django.

我正在使用 PostgreSQL 数据库引擎后端配置 Django 项目，但我在每个数据库操作中都遇到错误.例如，当我运行 manage.py syncdb 时，我得到:

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:xampphtdocsdjangodir>python manage.py syncdb
Traceback (most recent call last):
  File "manage.py", line 11, in <module>
    execute_manager(settings)
  File "C:Python27libsite-packagesdjangocoremanagement\__init__.py", line
438, in execute_manager
    utility.execute()
  File "C:Python27libsite-packagesdjangocoremanagement\__init__.py", line
379, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "C:Python27libsite-packagesdjangocoremanagement\__init__.py", line
261, in fetch_command
    klass = load_command_class(app_name, subcommand)
  File "C:Python27libsite-packagesdjangocoremanagement\__init__.py", line
67, in load_command_class
    module = import_module('%s.management.commands.%s' % (app_name, name))
  File "C:Python27libsite-packagesdjangoutilsimportlib.py", line 35, in im
port_module
    __import__(name)
  File "C:Python27libsite-packagesdjangocoremanagementcommandssyncdb.py"
, line 7, in <module>
    from django.core.management.sql import custom_sql_for_model, emit_post_sync_
signal
  File "C:Python27libsite-packagesdjangocoremanagementsql.py", line 6, in
 <module>
    from django.db import models
  File "C:Python27libsite-packagesdjangodb\__init__.py", line 77, in <modul
e>
    connection = connections[DEFAULT_DB_ALIAS]
  File "C:Python27libsite-packagesdjangodbutils.py", line 92, in __getitem
__
    backend = load_backend(db['ENGINE'])
  File "C:Python27libsite-packagesdjangodbutils.py", line 33, in load_back
end
    return import_module('.base', backend_name)
  File "C:Python27libsite-packagesdjangoutilsimportlib.py", line 35, in im
port_module
    __import__(name)
  File "C:Python27libsite-packagesdjangodbackendspostgresqlase.py", li
ne 23, in <module>
    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?

推荐答案

您需要安装psycopg2 Python 库.

You need to install psycopg2 Python library.

下载http://initd.org/psycopg/，然后安装在Python PATH下

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

下载后，轻松解压压缩包:

After downloading, easily extract the tarball and:

$ python setup.py install

或者，如果您愿意，也可以通过 easy_install 或 pip.

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

• $ easy_install psycopg2
• $ pip install psycopg2

在设置.py

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

这篇关于如何在 Django 中设置 PostgreSQL 数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！