django.db.utils.OperationalError无法连接到服务器

I am not sure how to fix this issue

我不知道如何解决这个问题

I have no idea why I am getting this error when I try to runserver:

我不知道为什么我在尝试runserver时遇到此错误：

Performing system checks...

System check identified no issues (0 silenced).
Unhandled exception in thread started by <function wrapper at 0x1085589b0>
Traceback (most recent call last):
  File "/Library/Python/2.7/site-packages/django/utils/autoreload.py", line 222, in wrapper
    fn(*args, **kwargs)
  File "/Library/Python/2.7/site-packages/django/core/management/commands/runserver.py", line 107, in inner_run
    self.check_migrations()
  File "/Library/Python/2.7/site-packages/django/core/management/commands/runserver.py", line 159, in check_migrations
    executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS])
  File "/Library/Python/2.7/site-packages/django/db/migrations/executor.py", line 17, in __init__
    self.loader = MigrationLoader(self.connection)
  File "/Library/Python/2.7/site-packages/django/db/migrations/loader.py", line 49, in __init__
    self.build_graph()
  File "/Library/Python/2.7/site-packages/django/db/migrations/loader.py", line 184, in build_graph
    self.applied_migrations = recorder.applied_migrations()
  File "/Library/Python/2.7/site-packages/django/db/migrations/recorder.py", line 59, in applied_migrations
    self.ensure_schema()
  File "/Library/Python/2.7/site-packages/django/db/migrations/recorder.py", line 49, in ensure_schema
    if self.Migration._meta.db_table in self.connection.introspection.get_table_list(self.connection.cursor()):
  File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py", line 165, in cursor
    cursor = self.make_debug_cursor(self._cursor())
  File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py", line 138, in _cursor
    self.ensure_connection()
  File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py", line 133, in ensure_connection
    self.connect()
  File "/Library/Python/2.7/site-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py", line 133, in ensure_connection
    self.connect()
  File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py", line 122, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/Library/Python/2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 134, in get_new_connection
    return Database.connect(**conn_params)
  File "/Library/Python/2.7/site-packages/psycopg2/__init__.py", line 164, in connect
    conn = _connect(dsn, connection_factory=connection_factory, async=async)
django.db.utils.OperationalError: could not connect to server: Connection refused
        Is the server running on host "127.0.0.1" and accepting
        TCP/IP connections on port 5432?

When I try to connect to postgres:

当我尝试连接到postgres时：

psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

settings.py:

settings.py：

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'beerad',
        'USER': 'bli1',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '5432',
    }
}

3 个解决方案

#1

It can be some issues:

这可能是一些问题：

PostgreSQL is not running. Check it with sudo service postgresql status
PostgreSQL没有运行。使用sudo service postgresql status检查它
Your PostgresSQl is not running on port 5432. You can check it typing sudo netstat -nl | grep postgres

您的PostgresSQl未在端口5432上运行。您可以在输入sudo netstat -nl |进行检查grep postgres
You have something wrong trying to connect to your db like the username, the password or the databasename. Check that they are what postgres ask for you to connect it and that is the db_name that you want to access to.

尝试连接到数据库时遇到错误，例如用户名，密码或数据库名。检查它们是什么postgres要求您连接它，这是您要访问的db_name。
Problems with postmaster.pid in postgres. It can happen because of a shutdown unproperly done. It makes to remind a pid alive that doesn't allow your server start. To fix it you have to:

postgres中postmaster.pid的问题。由于未正确完成关闭，可能会发生这种情况。它提醒一个不允许你的服务器启动的pid活着。要解决它，你必须：
```
 * rm /usr/local/var/postgres/postmaster.pid 
 * pg_resetxlog -f /usr/local/var/postgres
```
After this it should run properly if you make the runserver of postgres

在此之后，如果你制作postgres的runserver，它应该正常运行

Help in Mac OSX: How to start PostgreSQL server on Mac OS X?

Mac OSX中的帮助：如何在Mac OS X上启动PostgreSQL服务器？

#2

Try killing all postgres processes. Im on a MAC and this solution that I've found on ubuntus forum really works.

尝试杀死所有postgres进程。我在MAC上，我在ubuntus论坛上找到的这个解决方案确实有效。

https://askubuntu.com/questions/547434/how-to-nicely-stop-all-postgres-processes

#3

For Windows

对于Windows

Go to search bar and just write "Open psql" and hit Enter.

转到搜索栏，然后单击“打开psql”并按Enter键。

Once screen is opened, rerun django project.

打开屏幕后，重新运行django项目。

#1