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

Put on the PostgreSQL server.
Created a user for the connection.
Asked for a password.
Created database and pointed out that the owner of the created user.
In settings py changed:
'default': {
 'ENGINE': 'django.db.backends.postgresql_psycopg2',
 'NAME': 'django_db1',
 'USER': 'user',
 'PASSWORD': 'pass66',
 'HOST': 'server Ip',
 'PORT': '5432',
}
}

Config postgresql
listen_addresses = 'ip of server'

error when trying
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 "my ip" and accepting
 TCP/IP connections on port 5432?</module>


Checked Postgres works.
What's wrong?
The issue has been resolved, in settings.py you need to specify the HOST to 127.0.0.1
June 26th 19 at 14:19
2 answers
June 26th 19 at 14:21
If the database locally, there is no need to bother with ip, but to register anywhere localhost, type
'HOST': 'localhost',
It's on the server - Christiana_Gutmann commented on June 26th 19 at 14:24
June 26th 19 at 14:23
99% of pg_hba.conf
the remaining 1% - the firewall

Find more questions by tags PostgreSQLDjango