Postgresql + django (Is the server running on host «ip» and accepting TCP/IP connections on port 5432?

Question

[xxx]

Поставил на сервер PostgreSQL.
Создал юзера для подключения.
Задал пароль.
Создал БД и указал, что владелец созданный до этого юзер.
В settings py поменял:

'default': {
         'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'django_db1',
        'USER': 'user',
        'PASSWORD': 'pass66',
        'HOST': 'Ip сервера',
        'PORT': '5432',
    }
}

В конфиге postgresql
listen_addresses = 'ip сервера'

ошибка при попытке
python manage.py migrate

@debian:/var/www/myblog_project/mysite$ python manage.py migrate
Traceback (most recent call last):
  File "manage.py", line 22, in <module>
    execute_from_command_line(sys.argv)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 363, in execute_from_command_line
    utility.execute()
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 355, 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 283, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 330, in execute
    output = self.handle(*args, **options)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/migrate.py", line 83, 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 52, in __init__
    self.build_graph()
  File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/loader.py", line 209, 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 254, in cursor
    return self._cursor()
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 229, in _cursor
    self.ensure_connection()
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 213, in ensure_connection
    self.connect()
  File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 94, 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 213, in ensure_connection
    self.connect()
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 189, 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 176, in get_new_connection
    connection = Database.connect(**conn_params)
  File "/usr/local/lib/python2.7/dist-packages/psycopg2/__init__.py", line 130, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: could not connect to server: Connection refused
	Is the server running on host "мой ip" and accepting
	TCP/IP connections on port 5432?

Проверял, постгрес работает.
Что не так?
Вопрос решен, в settings.py нужно в HOST указать 127.0.0.1

Comments

[Сергей Горностаев]

Команда

psql -h <ip сервера> -U <имя пользователя> <имя базы>

подключает к серверу или ошибку выдаёт?

[xxx]

Сергей Горностаев: Ошибка

[Сергей Горностаев]

Ivan Ch: какая?

[xxx]

Сергей Горностаев: psql: could not connect to server: Connection refused
Is the server running on host "ip" and accepting
TCP/IP connections on port 5432?

[Сергей Горностаев]

Ivan Ch: поздравляю, либо сервер не работает на этом адресе, либо блокируется брандмауэром, либо проверяйте pg_hba.conf

Answer 1

[Макс]

99% - pg_hba.conf
остальной 1% - файрвол