hey, can you give more information about your code? What are you using to connect to your database?

I use pgAdmin 4

it works last months

I'm looking more on what ORM/library you're using to connect to your database that is giving out INTERNAL SERVER ERRORs

API Server can connect to DB, but I cann't connect to DB

I see this warning today

Api server use nodejs + prisma, it works, Doesn't work remote connection

still not works

Can you please confirm the value of which that variable is set to? Not the actual value, but what variables it's referencing. For example, postgresql://${{PGUSER}}:${{POSTGRES_PASSWORD}}@${{RAILWAY_TCP_PROXY_DOMAIN}}:${{RAILWAY_TCP_PROXY_PORT}}/${{PGDATABASE}}

Additionally, is there any more information you could get about the error you're getting? It's pretty vague. What are client are you using to connect? Does the viewer built into Railway work?

Couple of things:

1 - The warning about the public URL of the database has always been there. Railway basically recommends always connecting through the internal URL to avoid egress feeds. Additionally, for security reasons, it is good practice to keep the database from being openly exposed to the Internet.

2 - Can you provide a more detail stack trace, logs, or something about the error, so we can look at it in order to find the error

3 - Try the good old restart the service, go to the last deployment, in the 3 dots, click redeploy... and try again

I use variable DATABASE_PUBLIC_URL

it works always but stop today

Please read the bullets that @root101 wrote

Also, you just posted your database access URL. I would recommend deleting that. Reset that password immediately.

And do not by any means share your password for it here... even though you already did.

And FYI, I can connect just fine. Something is wrong with whatever you're using to connect, or how you set that up.

@loudbook, i just say i was gonna share it, not worries, i will delete the db soon enough, is just a test

Not you. OP shared their password in an above message.

I've changed password in the link.

I disconnect from server and then connect to server in pgAdmin 4. it works now.

But other container seems has the same problem

Awesome. Change the password for it too.

Root, do not ask for people's database credentials. vk, it's extremely risky to share credentials with anyone, they're like a password for your database.

I've deleted both URLs from this thread. Please be more careful in the future

hi adam, i just say it was not recommended, just trying to reproduce the error on my end..... i even share a test DB (That bd im deleteing it like now)

It shouldn't have been listed as an option.

okay, noted

Another container within the same project? That's also pgAdmin?

yes, , it is the same group of projects

https://railway.com/project/db6dfaa4-f18d-482d-96fc-bdd31078d43c/service/a2981f82-a255-4466-80c7-b4b405f65854. it is PHP based site. , Seems like connect is stuck too. But remote connect works, I'll work on it tomorrow

as i said in point #3, good old restart all (including conections in pgadmin)

So, is it in the same project? Or in a different project?

That link is not something we can view because your project is private.