Can't connect to Postgres db by dbeaver
cesarsouza13
HOBBYOP

a year ago

Good morning, I'm trying to connect to my Postgres database generated by Railway, and even passing the URL and credentials generated by Railway, it's not possible.

I have another database generated by Railway, but it's MySql, and I don't have this problem connecting via Dbeaver.

I have already checked all the credentials

Solved

9 Replies

cesarsouza13
HOBBYOP

a year ago

I can't even use public URL


cesarsouza13

I can't even use public URL

a year ago

Hey, have you checked if the TCP proxy is set up correctly?

https://docs.railway.com/guides/public-networking#tcp-proxying


cesarsouza13
HOBBYOP

a year ago


This is the default configuration that came

Attachments


cesarsouza13

This is the default configuration that came

a year ago

Do you have any data in the database in question? If you don't, it is probably faster to just spin up a new database. Furthermore, what's the error message when attempting to connect to the database via the private and/or public networking? Have you successfully connected to it in the past and did you change any service variables?


uxuz

Do you have any data in the database in question? If you don't, it is probably faster to just spin up a new database. Furthermore, what's the error message when attempting to connect to the database via the private and/or public networking? Have you successfully connected to it in the past and did you change any service variables?

cesarsouza13
HOBBYOP

a year ago

I want to dump my local database to my Railway database and I will be able to do so only when I connect the Railway database to my dbeaver. Now, about the error in dbeaver, the error just displays the message "Failed to attempt connection" and specifies the URL in question.


cesarsouza13
HOBBYOP

a year ago

I solved


cesarsouza13

I solved

a year ago

I am glad that you have sold the issue, do you mind sharing what the root cause was?


cesarsouza13
HOBBYOP

a year ago

In dbeaver we have two connection options.

1- Passing the URL with all the credentials parameters

2- Set each parameter one by one

Option 1 did not work at all and I did not understand why. However, option 2 worked using the public URL generated by railway

Attachments


cesarsouza13

In dbeaver we have two connection options.1- Passing the URL with all the credentials parameters2- Set each parameter one by oneOption 1 did not work at all and I did not understand why. However, option 2 worked using the public URL generated by railway

a year ago

Thank you for your detailed reply! I'll keep this in mind if something like this happens again. For now, I'll mark this thread as solved.


Status changed to Solved uxuz 11 months ago


Loading...