I am trying to connect my local DBeaver to the postgress db i created on railway, but I keep getting the connection attempt failed. Im trying with both URL and host
#Can't connect postgress db in railway to DBeaver
dreamy solstice
quiet pollenBOT
dreamy solstice
ce9f612a-58ab-4b1e-a58f-ab59cfb943a3
mystic adder
Make sure you're using the public url for it (the one that ends with .proxy.rlwy.net instead of .railway.internal)
dreamy solstice
im using it and it tells me Invalid JDBC URL: postgresql://postgres:[email protected]:59235/railway
mystic adder
umm please don't post the full url if you care about security
altho, if you want me to check it, I could try to connect to ur db from my side
since you've just posted it's credentials anyway
dreamy solstice
yes please
mystic adder
yup the db and it's url are totally fine
has to be an issue with dbeaver itself
but please, make sure you don't use these exact db credentials later in production
opal tendon
perhaps it's an invalid JDBC url because it's not a JDBC formatted url?
mystic adder
ahh yes, dbeaver doesn't understand those pg urls
dreamy solstice
can you help me how to format my current url?
opal tendon
look at the screenshot please
dreamy solstice
oh okay thanks
dreamy solstice
I get The connection attempt failed. Connection reset
can you paste the values i need to use for the host?
and port
I've deleted the service because i copy pasted the public url and created a new one
opal tendon
the value you need to use for the host and port can be found in the service settings under public networking, and the username and password are found in the variables tab
opal tendon
!s