Блог

Я учусь использовать Django через учебник,в котором мы разрабатываем небольшой проект,
я пытаюсь подключить базу данных PostgresSQL и выполнить миграцию,
но у меня есть определенные проблемы при выполнении «python manage.py миграция» в терминале

Settings.py

 DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'DEMO_TEST',
        'USER' : 'postgresql',
        'HOST': 'localhost',
        'PASSWORD':'le123le123',
        'PORT': '5432',
    }
}
 

Обратная связь

   File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendsbasebase.py", line 219, in ensure_connection
    self.connect()
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangoutilsasyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendsbasebase.py", line 200, in connect
    self.connection = self.get_new_connection(conn_params)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangoutilsasyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendspostgresqlbase.py", line 187, in get_new_connection
    connection = Database.connect(**conn_params)
  File "C:Usersleanaconda3envsmyenvlibsite-packagespsycopg2__init__.py", line 122, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "manage.py", line 22, in <module>
    main()
  File "manage.py", line 18, in main
    execute_from_command_line(sys.argv)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangocoremanagement__init__.py", line 419, in execute_from_command_line
    utility.execute()
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangocoremanagement__init__.py", line 413, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangocoremanagementbase.py", line 354, in run_from_argv
    self.execute(*args, **cmd_options)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangocoremanagementbase.py", line 398, in execute
    output = self.handle(*args, **options)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangocoremanagementbase.py", line 89, in wrapped
    res = handle_func(*args, **kwargs)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangocoremanagementcommandsmigrate.py", line 75, in handle
    self.check(databases=[database])
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangocoremanagementbase.py", line 419, in check
    all_issues = checks.run_checks(
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangocorechecksregistry.py", line 76, in run_checks
    new_errors = check(app_configs=app_configs, databases=databases)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangocorechecksmodel_checks.py", line 34, in check_all_models
    errors.extend(model.check(**kwargs))
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbmodelsbase.py", line 1290, in check
    *cls._check_indexes(databases),
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbmodelsbase.py", line 1680, in _check_indexes
    connection.features.supports_covering_indexes or
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangoutilsfunctional.py", line 48, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendspostgresqlfeatures.py", line 93, in is_postgresql_11
    return self.connection.pg_version >= 110000
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangoutilsfunctional.py", line 48, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendspostgresqlbase.py", line 329, in pg_version
    with self.temporary_connection():
  File "C:Usersleanaconda3envsmyenvlibcontextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendsbasebase.py", line 603, in temporary_connection
    with self.cursor() as cursor:
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangoutilsasyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendsbasebase.py", line 259, in cursor
    return self._cursor()
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendsbasebase.py", line 235, in _cursor
    self.ensure_connection()
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangoutilsasyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendsbasebase.py", line 219, in ensure_connection
    self.connect()
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbutils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendsbasebase.py", line 219, in ensure_connection
    self.connect()
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangoutilsasyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendsbasebase.py", line 200, in connect
    self.connection = self.get_new_connection(conn_params)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangoutilsasyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:Usersleanaconda3envsmyenvlibsite-packagesdjangodbbackendspostgresqlbase.py", line 187, in get_new_connection
    connection = Database.connect(**conn_params)
  File "C:Usersleanaconda3envsmyenvlibsite-packagespsycopg2__init__.py", line 122, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError
 

Создайте учетную запись в PostgreSQL и попробуйте связать ее с Django, чтобы иметь таблицы, которые я уже создал в Sqlite3. Кто-нибудь, помогите мне, пожалуйста