Can't connect to Postgres db by dbeaver

cesarsouza13
HOBBY

3 months 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
HOBBY

3 months ago

I can't even use public URL


cesarsouza13

I can't even use public URL

3 months ago

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

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


cesarsouza13
HOBBY

3 months ago


This is the default configuration that came

Attachments


cesarsouza13

This is the default configuration that came

3 months 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
HOBBY

3 months 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
HOBBY

3 months ago

I solved


cesarsouza13

I solved

3 months ago

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


cesarsouza13
HOBBY

3 months 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

3 months 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 3 months ago