please provide specific error messages

Server Error (500)

I'm going to need something far more detailed than that, like errors in your deployment logs

OperationalError at /
connection to server at "containers-us-west-36.railway.app" (35.197.122.57), port 5876 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?

File "/opt/venv/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner

return func(*args, **kwargs)

File "/opt/venv/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in getnewconnection

connection = self.Database.connect(**conn_params)

File "/opt/venv/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect

conn = connect(dsn, connectionfactory=connection_factory, **kwasync)

psycopg2.OperationalError: connection to server at "containers-us-west-36.railway.app" (35.197.122.57), port 5876 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 "/opt/venv/lib/python3.10/site-packages/django/core/handlers/exception.py", line 55, in inner

response = get_response(request)

File "/opt/venv/lib/python3.10/site-packages/django/core/handlers/base.py", line 197, in getresponse

response = wrappedcallback(request, *callbackargs, **callback_kwargs)

File "/app/main/views.py", line 15, in home

expatad_count = expatads.count()

File "/opt/venv/lib/python3.10/site-packages/django/db/models/query.py", line 608, in count

return self.query.get_count(using=self.db)

File "/opt/venv/lib/python3.10/site-packages/django/db/models/sql/query.py", line 539, in get_count

return obj.get_aggregation(using, {"count": Count("*")})["count"]

File "/opt/venv/lib/python3.10/site-packages/django/db/models/sql/query.py", line 525, in get_aggregation

result = compiler.execute_sql(SINGLE)

File "/opt/venv/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1558, in execute_sql

cursor = self.connection.cursor()

File "/opt/venv/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner

return func(*args, **kwargs)

File "/opt/venv/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor

return self._cursor()

File "/opt/venv/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor

self.ensure_connection()

File "/opt/venv/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner

return func(*args, **kwargs)

File "/opt/venv/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection

with self.wrapdatabaseerrors:

File "/opt/venv/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit

raise djexcvalue.withtraceback(traceback) from excvalue

File "/opt/venv/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection

self.connect()

File "/opt/venv/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner

return func(*args, **kwargs)

File "/opt/venv/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect

self.connection = self.getnewconnection(conn_params)

File "/opt/venv/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner

return func(*args, **kwargs)

File "/opt/venv/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in getnewconnection

connection = self.Database.connect(**conn_params)

File "/opt/venv/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect

conn = connect(dsn, connectionfactory=connection_factory, **kwasync)

django.db.utils.OperationalError: connection to server at "containers-us-west-36.railway.app" (35.197.122.57), port 5876 failed: Connection refused

Is the server running on that host and accepting TCP/IP connections?

My Postgress database hosted by Railwayapp.
My Previous Host and port (Old Database Host name and port)
HOST=containers-us-west-36.railway.app
PORT=5876

New Database after upgrade i got following Host and port No.
'HOST': 'monorail.proxy.rlwy.net',
'PORT': '42328',

please see this guide https://docs.railway.app/guides/database-migration-guide#switching-over-connections