我终于(认为)成功安装了 PostgreSQL 和 de psycopg2(我使用 Windows)。顺便说一句，有什么方法可以检查它是否正常工作？

好吧，现在的问题是我无法启动服务器，当我键入“python manage.py runserver”时它显示了这个(在命令末尾):

conn = _connect(dsn, connection_factory=connection_factory, async=async)
django.db.utils.OperationalError: could not connect to server: Connection refused (0x0000274D/10061)
    Is the server running on host "localhost" (::1) and accepting
    TCP/IP connections on port 8000?
could not connect to server: Connection refused (0x0000274D/10061)
    Is the server running on host "localhost" (127.0.0.1) and accepting
    TCP/IP connections on port 8000?

我已经搜索了很多关于它的文档，例如 in this topic ，但我找不到让它正常工作的方法。我已经尝试对 pg_hba 和 postgresql 文件进行几处更改，但没有退出。此时，pg_hba 看起来像:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1            md5
# IPv6 local connections:
host    all             all             127.0.0.1            md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5

而 postgresql conf 看起来像:

# - Connection Settings -

listen_addresses = 'localhost'      # what IP address(es) to listen on;
                # comma-separated list of addresses;
                # defaults to 'localhost'; use '*' for all
                # (change requires restart)
port = 8000             # (change requires restart)
max_connections = 100           # (change requires restart)
# Note:  Increasing max_connections costs ~400 bytes of shared memory per
# connection slot, plus lock space (see max_locks_per_transaction).
#superuser_reserved_connections = 3 # (change requires restart)
#unix_socket_directories = ''   # comma-separated list of directories
                # (change requires restart)
#unix_socket_group = ''         # (change requires restart)
#unix_socket_permissions = 0777     # begin with 0 to use octal notation
                # (change requires restart)
#bonjour = off              # advertise server via Bonjour
                # (change requires restart)
#bonjour_name = ''          # defaults to the computer name

顺便说一句，我的数据库 settings.py 看起来像这样:

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.postgresql_psycopg2',
    'NAME': 'database1',                      
    'USER': 'root',
    'PASSWORD': '123456',
    'HOST': 'localhost',
    'PORT': '8000',
    }
}

顺便说一句，我还没有创建数据库，我应该怎么做？ PostgreSQL提示符有哪些应用？

我非常感谢能帮助我解决这个问题，我已经搜索和尝试了好几天，但没有成功。非常感谢。

编辑 1: 我尝试将 settings.py 端口更改为 5432，但现在错误消息是一样的，只是更改了端口:

could not connect to server: Connection refused (0x0000274D/10061)
    Is the server running on host "localhost" (127.0.0.1) and accepting
    TCP/IP connections on port 5432?

配置文件是这样的吗？我应该改变什么吗？我找不到答案。我尝试使用 python manage.py runserver 并同时指示 127.0.0.1:8000 和 8001，但错误消息没有变化。出了什么问题？非常感谢。

最佳答案

对我来说，这是因为 postgres 没有启动和启用。所以我通过这样做解决了问题:

sudo systemctl start postgresql
sudo systemctl enable postgresql

关于python - 无法在 Django 上运行服务器(连接被拒绝)，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/35455109/