Re: django.db.utils.OperationalError: server closed the connection unexpectedly

Dear Antonis,

Thank you very much for your quick response.

Sorry, I am newer in this field. I was trying to install LitDB (http://www.ikmb.uni-kiel.de/litdb)

I changed the settings as what your suggestion, but not happened.

with port number 5432, it showing

 Is the server running on host "localhost" (::1) and accepting

        TCP/IP connections on port 5432?

could not connect to server: Connection refused

        Is the server running on host "localhost" (127.0.0.1) and accepting

        TCP/IP connections on port 5432?

Is there any other settings i need to change?

Thanks and Regards

Bobby Paul

On Wednesday, May 31, 2017 at 5:14:29 PM UTC+5:30, Bobby Paul wrote:

Dear All,

I am getting this error message while trying to install psql database.

 File "setup.py", line 18, in <module>

    execute_from_command_line(['manage.py','migrate'])

  File "/usr/local/bin/lib/python2.7/site-packages/django/core/management/__init__.py", line 354, in execute_from_command_line

    utility.execute()

  File "/usr/local/bin/lib/python2.7/site-packages/django/core/management/__init__.py", line 346, in execute

    self.fetch_command(subcommand).run_from_argv(self.argv)

  File "/usr/local/bin/lib/python2.7/site-packages/django/core/management/base.py", line 394, in run_from_argv

    self.execute(*args, **cmd_options)

  File "/usr/local/bin/lib/python2.7/site-packages/django/core/management/base.py", line 445, in execute

    output = self.handle(*args, **options)

  File "/usr/local/bin/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 93, in handle

    executor = MigrationExecutor(connection, self.migration_progress_callback)

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/migrations/executor.py", line 19, in __init__

    self.loader = MigrationLoader(self.connection)

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/migrations/loader.py", line 47, in __init__

    self.build_graph()

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/migrations/loader.py", line 191, in build_graph

    self.applied_migrations = recorder.applied_migrations()

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/migrations/recorder.py", line 59, in applied_migrations

    self.ensure_schema()

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/migrations/recorder.py", line 49, in ensure_schema

    if self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()):

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/backends/base/base.py", line 162, in cursor

    cursor = self.make_debug_cursor(self._cursor())

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/backends/base/base.py", line 135, in _cursor

    self.ensure_connection()

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/backends/base/base.py", line 130, in ensure_connection

    self.connect()

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/utils.py", line 98, in __exit__

    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/backends/base/base.py", line 130, in ensure_connection

    self.connect()

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/backends/base/base.py", line 119, in connect

    self.connection = self.get_new_connection(conn_params)

  File "/usr/local/bin/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 176, in get_new_connection

    connection = Database.connect(**conn_params)

  File "/usr/local/bin/lib/python2.7/site-packages/psycopg2/__init__.py", line 130, in connect

    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)

django.db.utils.OperationalError: server closed the connection unexpectedly

        This probably means the server terminated abnormally

        before or while processing the request.

==========

DATABASES_DEFAULT = {

        'ENGINE': 'django.db.backends.postgresql_psycopg2',

        'NAME': 'litdb',

        'USER': 'root',

        'PASSWORD': '',

        'HOST': 'localhost',

        'PORT': '80',

}

How to sort this issue?

Kind Regards

Bobby Paul

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/c367c3b4-502b-49ec-94e3-10a0433ccb99%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.