Postgres Connection Error
My app is unable to connect with railway's postgres service.
Also, when I used
DATABASE_URL
dbgate error is -
Error: Connection terminated unexpectedly
at e.exports.<anonymous> (/Applications/DbGate.app/Contents/Resources/app.asar/packages/plugins/dbgate-plugin-postgres/dist/backend.js:17:175293)
at Object.onceWrapper (node:events:509:28)
at e.exports.emit (node:events:390:28)
at Socket.<anonymous> (/Applications/DbGate.app/Contents/Resources/app.asar/packages/plugins/dbgate-plugin-postgres/dist/backend.js:9:141124)
at Socket.emit (node:events:402:35)
at endReadableNT (node:internal/streams/readable:1343:12)
at processTicksAndRejections (node:internal/process/task_queues:83:21)
Please help π![No description](https://cdn.answeroverflow.com/1175397816332451910/db-connection-error.png)
![No description](https://cdn.answeroverflow.com/1175397816630259742/invalid-response.png)
28 Replies
Project ID:
6df8fc82-10e0-4b56-ab0b-b2ce2d7e52b5
6df8fc82-10e0-4b56-ab0b-b2ce2d7e52b5
can you try restarting the database?
did restart, still same error in console and dbgate
![No description](https://cdn.answeroverflow.com/1175686235675688980/restart-db.png)
Also, I cannot find a railway link
xxxx-xxx-production.up.railway.app
to my deployed app even after I do railway up
..is it because my db is unable to connect?restart the database, not your app
if you don't have a domain yet, go to the service settings and generate one
this is probably very basic - how should I restart my db?
depends on if you have a legacy database or a database service.
does your database have a volume?
Yes, my db has a volume
then you restart it the same way you restart a deployment
As I did here?
yes but restart the database, not your app
This is probably too much handholding, but please can you send me screenshots of steps β sorry for trouble
open the database and click this highlighted button in the 3 dot menu
![No description](https://cdn.answeroverflow.com/1176072498920575017/restart-db.png)
Already did, same error