Guys, when i upload a bot using database of railway, i need to put private database address, sure?
But i'm having a stupid crash (when i commit my bot to railway):
Traceback (most recent call last):
File "/app/main.py", line 2, in <module>
import discordModules.auth as auth
File "/app/discordModules/auth.py", line 1, in <module>
import asyncio, clientCommands
File "/app/clientCommands.py", line 1, in <module>
import clientModules.events.on_message
File "/app/clientModules/events/on_message.py", line 5, in <module>
from database import connection as db
File "/app/database/connection.py", line 19, in <module>
conn = psycopg2.connect(
^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/psycopg2/init.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.OperationalError: could not translate host name "postgres.railway.internal" to address: Name or service not known
20 Replies
Project ID:
e8ff4539-1a96-47e7-9a34-64bcaf87d9b1e8ff4539-1a96-47e7-9a34-64bcaf87d9b1
is the database in the same project as the bot?
Yes
it is
:cat_happy:
make sure you are on the v2 runtime
how can i do it
in the service settings
here?
of the bot service
What this means
runtime v2
please see this docs page - https://docs.railway.app/reference/runtime
When did that change? I guess that's why I was paying so much for my bills
💀
the runtime wouldnt have anything to do with billing
Isn't using the “Internal” version the right thing to do? Isn't the public one that if a lot of people use it, it costs a lot?
correct, you are using the internal host and port so you are good
I made a statement in try to automatically connect to the internal, and if it couldn't, to use the standard connection, and as railway simply put it as “v2”, all my clients were accessing the public version, instead of the internal one
🤡
im not sure i follow
:thinkies: