Django 中使用 PostgreSQL 本地同步数据库报错“Please supply the ENGINE value”
包,这是 Python 用于连接 PostgreSQL 数据库的库。错误原因是缺少数据库引擎配置。如果您的数据库配置正确,则应该能够成功同步数据库。
·
在使用 Django 进行本地数据库同步时,可能会遇到以下错误:
python manage.py syncdb
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/home/wtodom/hellodjango/venv/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 443, in execute_from_command_line
utility.execute()
File "/home/wtodom/hellodjango/venv/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 382, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/wtodom/hellodjango/venv/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 261, in fetch_command
klass = load_command_class(app_name, subcommand)
File "/home/wtodom/hellodjango/venv/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 69, in load_command_class
module = import_module('%s.management.commands.%s' % (app_name, name))
File "/home/wtodom/hellodjango/venv/local/lib/python2.7/site-packages/django/utils/importlib.py", line 35, in import_module
__import__(name)
File "/home/wtodom/hellodjango/venv/local/lib/python2.7/site-packages/django/core/management/commands/syncdb.py", line 8, in <module>
from django.core.management.sql import custom_sql_for_model, emit_post_sync_signal
File "/home/wtodom/hellodjango/venv/local/lib/python2.7/site-packages/django/core/management/sql.py", line 6, in <module>
from django.db import models
File "/home/wtodom/hellodjango/venv/local/lib/python2.7/site-packages/django/db/__init__.py", line 11, in <module>
if DEFAULT_DB_ALIAS not in settings.DATABASES:
File "/home/wtodom/hellodjango/venv/local/lib/python2.7/site-packages/django/utils/functional.py", line 184, in inner
self._setup()
File "/home/wtodom/hellodjango/venv/local/lib/python2.7/site-packages/django/conf/__init__.py", line 42, in _setup
self._wrapped = Settings(settings_module)
File "/home/wtodom/hellodjango/venv/local/lib/python2.7/site-packages/django/conf/__init__.py", line 95, in __init__
raise ImportError("Could not import settings '%s' (Is it on sys.path?): %s" % (self.SETTINGS_MODULE, e))
ImportError: Could not import settings '/home/wtodom/hellodjango/hellodjango/settings.py' (Is it on sys.path?): Import by filename is not supported.
2. 解决方案
错误原因是缺少数据库引擎配置。要解决此问题,请按照以下步骤操作:
- 打开项目目录下的
settings.py
文件。 - 在
DATABASES
字典中,添加以下配置:
{
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'YOUR_DATABASE_NAME',
'USER': 'YOUR_DATABASE_USER',
'PASSWORD': 'YOUR_DATABASE_PASSWORD',
'HOST': 'YOUR_DATABASE_HOST',
'PORT': 'YOUR_DATABASE_PORT',
}
}
- 将
YOUR_DATABASE_NAME
替换为您的数据库名称。 - 将
YOUR_DATABASE_USER
替换为您的数据库用户名。 - 将
YOUR_DATABASE_PASSWORD
替换为您的数据库密码。 - 将
YOUR_DATABASE_HOST
替换为您的数据库主机地址。 - 将
YOUR_DATABASE_PORT
替换为您的数据库端口号。
确保已安装 psycopg2
包,这是 Python 用于连接 PostgreSQL 数据库的库。您可以使用以下命令安装:
pip install psycopg2
保存 settings.py
文件,然后再次运行 python manage.py syncdb
命令。如果您的数据库配置正确,则应该能够成功同步数据库。

DAMO开发者矩阵,由阿里巴巴达摩院和中国互联网协会联合发起,致力于探讨最前沿的技术趋势与应用成果,搭建高质量的交流与分享平台,推动技术创新与产业应用链接,围绕“人工智能与新型计算”构建开放共享的开发者生态。
更多推荐
所有评论(0)