致命错误：数据库不存在

问题描述：

我有一个困难的时间与postgres设置django。致命错误：数据库不存在

这里是我的settings.py：

DATABASES = { 
    'default': { 
     'ENGINE': 'django.db.backends.postgresql', 
     'HOST': 'localhost', 
     'NAME': 'collector', 
     'USER': 'collector_user', 
     'PASSWORD': 'collector' 
    } 
}

我创建了密码收集用户collector_user在Postgres的第一步网站。还创建了收集器模式：

postgres=# select nspname from pg_catalog.pg_namespace; 
     nspname  
-------------------- 
pg_toast 
pg_temp_1 
pg_toast_temp_1 
pg_catalog 
public 
information_schema 
collector 
(7 rows)

这里是什么Django的不得不说的是：

Traceback (most recent call last): 
    File "manage.py", line 10, in <module> 
    execute_from_command_line(sys.argv) 
    File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 353, in execute_from_command_line 
    utility.execute() 
    File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 345, in execute 
    self.fetch_command(subcommand).run_from_argv(self.argv) 
    File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 348, in run_from_argv 
    self.execute(*args, **cmd_options) 
    File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 399, in execute 
    output = self.handle(*args, **options) 
    File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/migrate.py", line 89, in handle 
    executor = MigrationExecutor(connection, self.migration_progress_callback) 
    File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/executor.py", line 20, in __init__ 
    self.loader = MigrationLoader(self.connection) 
    File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/loader.py", line 49, in __init__ 
    self.build_graph() 
    File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/loader.py", line 176, in build_graph 
    self.applied_migrations = recorder.applied_migrations() 
    File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/recorder.py", line 65, in applied_migrations 
    self.ensure_schema() 
    File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/recorder.py", line 52, in ensure_schema                   
    if self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()):                   
    File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 231, in cursor 
    cursor = self.make_debug_cursor(self._cursor()) 
    File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 204, in _cursor 
    self.ensure_connection() 
    File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 199, in ensure_connection 
    self.connect() 
    File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 95, in __exit__ 
    six.reraise(dj_exc_type, dj_exc_value, traceback) 
    File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 199, in ensure_connection 
    self.connect() 
    File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 171, in connect 
    self.connection = self.get_new_connection(conn_params) 
    File "/usr/local/lib/python2.7/dist-packages/django/db/backends/postgresql/base.py", line 175, in get_new_connection 
    connection = Database.connect(**conn_params) 
    File "/usr/local/lib/python2.7/dist-packages/psycopg2/__init__.py", line 164, in connect 
    conn = _connect(dsn, connection_factory=connection_factory, async=async) 
django.db.utils.OperationalError: FATAL: database "collector" does not exist

我也试过下降数据库和用户，尝试重新建立它。它也没有工作。可能是什么问题？有没有我没有做的事情？我是新来的postgres，我通常在MySQL上工作。

显示输出\ l – Rhim

答

在PostgreSQL中，架构不是数据库。您在名为'postgres'的数据库中创建了一个名为'collector'的模式。但是你试图连接到名为'collector'的数据库。这不存在，因为你没有创建它。您应该创建一个名为'collector'的数据库，然后仅保留架构（即默认为“公共”）。

创建的“Postgres的数据库的新模式通常是不好的做法，无论如何，作为名为”Postgres的数据库通常应该保留给系统维护任务。

这改变了一切！我创建了数据库，现在它工作。谢谢！ –

致命错误：数据库不存在

相关推荐