2 months ago
there is a Database connection issue that is happening. see screenshot. It's giving the error message:
bash: line 1: psql: command not found.
it keeps trying to connect but the error just keeps occurring.
Attachments
2 Replies
Status changed to Awaiting Railway Response Railway • about 2 months ago
2 months ago
Have you tried redeploying your DB? Can you connect to the DB using a DB client?
2 months ago
Hi! The issue is that you're using the official Docker Hub postgres image rather than Railway's postgres template.
The Database tab in the UI connects via SSH and runs psql to interact with your database. In the official Docker Hub image, psql is located at /usr/lib/postgresql//bin/psql and requires profile scripts to add it to PATH. Railway's SSH session doesn't source those profile files, so psql isn't found.
To fix this, you have two options:
-
Switch to Railway's Postgres template - Deploy a new Postgres service using the "Add New Service" → "Database" → "Postgres" option. This uses
ghcr.io/railwayapp-templates/postgres-sslwhich is designed to work with the Database UI. -
Keep the official image but use external tools - If you need to stay on the Docker Hub image for a specific reason, you can connect to your database using external tools like TablePlus, pgAdmin, or
psqlfrom your local machine using the connection string from the Variables tab.
Let me know if you need help migrating to the Railway template or connecting with an external tool!
Status changed to Awaiting User Response Railway • about 2 months ago
a month ago
This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!
Status changed to Solved Railway • about 1 month ago