a year ago
I cannot get this to work. I have the name, user, password, host, and port all configured properly in the postgresql railway service. I can also see my github deployment is properly loading the variables from the service, yet I am still getting this error. Django works fine locally with postgresql. I am following the railway deployment guide. https://docs.railway.com/guides/django
res = handle_func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/core/management/commands/migrate.py", line 100, in handle self.check(databases=[database]) File "/opt/venv/lib/python3.11/site-packages/django/core/management/base.py", line 486, in check all_issues = checks.run_checks( ^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/core/checks/registry.py", line 88, in run_checks new_errors = check(app_configs=app_configs, databases=databases) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/core/checks/model_checks.py", line 36, in check_all_models errors.extend(model.check(**kwargs)) ^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/db/models/base.py", line 1617, in check *cls._check_constraints(databases), ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/db/models/base.py", line 2467, in _check_constraints connection.features.supports_nulls_distinct_unique_constraints File "/opt/venv/lib/python3.11/site-packages/django/utils/functional.py", line 47, in __get__ res = instance.__dict__[self.name] = self.func(instance) ^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/db/backends/postgresql/features.py", line 141, in is_postgresql_15 return self.connection.pg_version >= 150000 ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/utils/functional.py", line 47, in __get__ res = instance.__dict__[self.name] = self.func(instance) ^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/db/backends/postgresql/base.py", line 438, in pg_version with self.temporary_connection(): File "/root/.nix-profile/lib/python3.11/contextlib.py", line 137, in __enter__ return next(self.gen) ^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 691, in temporary_connection with self.cursor() as cursor: ^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 316, in cursor return self._cursor() ^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 292, in _cursor self.ensure_connection() File "/opt/venv/lib/python3.11/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 274, in ensure_connection with self.wrap_database_errors: File "/opt/venv/lib/python3.11/site-packages/django/db/utils.py", line 91, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/opt/venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 275, in ensure_connection self.connect() File "/opt/venv/lib/python3.11/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 256, in connect self.connection = self.get_new_connection(conn_params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/django/db/backends/postgresql/base.py", line 277, in get_new_connection connection = self.Database.connect(**conn_params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/psycopg/connection.py", line 98, in connect attempts = conninfo_attempts(params) ^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/venv/lib/python3.11/site-packages/psycopg/_conninfo_attempts.py", line 50, in conninfo_attempts raise e.OperationalError(str(last_exc)) django.db.utils.OperationalError: [Errno -2] Name or service not known [View Deploy details](https://railway.com/project/facff695-8068-41d3-b3b3-16d533d51bae/service/d8e726a2-95ba-42fe-9434-ab16d3acb9bf?id=7a10c7f0-d84d-4d81-829c-c9d992d3792b) > ⓘ Deployment information is only viewable by project members and Railway employees.
0 Replies