sabaimran
commented
6 months ago Hi @Fuckingnameless , it looks like you're using the python package in this issue, rather than the docker file?
Is it possible you have another postgres instance up and running? Would you be able to check and kill any active processes, as described in this post? Check via lsof -n -i:5432 | grep LISTEN.
Otherwise, can you try removing the volume and starting the container again from scratch? It's possible it was initialized previously with a different config.
- Run
docker volume lsto get the correct volume name. It's probably something likekhoj_khoj_db - Run
docker volume rmto delete the volume. - Run
docker-compose upwith the same config to try and recreate the volume.
Just make sure first that you don't have the Postgres engine running on your machine.
Fuckingnameless
kalle07
cat pyvenv.cfg home = /usr/bin include-system-site-packages = false version = 3.9.2
~/AI/khoj/env2$ khoj --anonymous-mode
Traceback (most recent call last): File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection self.connect() File "/home/dietpi/.local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, *kwargs) File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 270, in connect self.connection = self.get_new_connection(conn_params) File "/home/dietpi/.local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(args, kwargs) File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connection connection = self.Database.connect(conn_params) File "/home/dietpi/.local/lib/python3.9/site-packages/psycopg2/init.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections?
The above exception was the direct cause of the following exception:
Traceback (most recent call last): File "/usr/local/bin/khoj", line 5, in
from khoj.main import run
File "/usr/local/lib/python3.9/dist-packages/khoj/main.py", line 42, in
call_command("migrate", "--noinput")
File "/home/dietpi/.local/lib/python3.9/site-packages/django/core/management/init.py", line 194, in call_command
return command.execute(*args, defaults)
File "/home/dietpi/.local/lib/python3.9/site-packages/django/core/management/base.py", line 458, in execute
output = self.handle(*args, *options)
File "/home/dietpi/.local/lib/python3.9/site-packages/django/core/management/base.py", line 106, in wrapper
res = handle_func(args, kwargs)
File "/home/dietpi/.local/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 117, in handle
executor = MigrationExecutor(connection, self.migration_progress_callback)
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/migrations/executor.py", line 18, in init
self.loader = MigrationLoader(self.connection)
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/migrations/loader.py", line 58, in init
self.build_graph()
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/migrations/loader.py", line 235, in build_graph
self.applied_migrations = recorder.applied_migrations()
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrations
if self.has_table():
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/migrations/recorder.py", line 57, in has_table
with self.connection.cursor() as cursor:
File "/home/dietpi/.local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, kwargs)
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 330, in cursor
return self._cursor()
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 306, in _cursor
self.ensure_connection()
File "/home/dietpi/.local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, *kwargs)
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection
self.connect()
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/utils.py", line 91, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection
self.connect()
File "/home/dietpi/.local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner
return func(args, kwargs)
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 270, in connect
self.connection = self.get_new_connection(conn_params)
File "/home/dietpi/.local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, kwargs)
File "/home/dietpi/.local/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connection
connection = self.Database.connect(conn_params)
File "/home/dietpi/.local/lib/python3.9/site-packages/psycopg2/init.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: connection to server at "localhost" (::1), port 5432 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?