Please I need a step by step to help fix this issue.
I did find this other question, but the answer did nothing to solve my problem:
I have clicked on Connect to database from DBeaver and I have entered in my INTERNAL_DB_URL to the URL
I have added my PROD_USER to Username
I have added PROD_DB_PASS to Password
Port is correct
Tested connection and it fails.
Or if I cannot migrate from DBeaver, how can I manually re-create my tables in my DB created on Render?
Going to try this on Heroku
I was able to connect using pgAdmin 4!
Hi Leon,
First, I would highly recommend you create a new database and delete your current one. You have posted a screenshot of your password into a public forum. I have marked this forums post as unlisted so less eyes will be able to see it.
For DBeaver, as it is a Java-based application, it requires a URL in JDBC format, not the format we provide in our connection strings. When I use it, I use the Connect By: Host option, as I can never remember the correct URL format for JDBC.
Settings should match the settings we give you on your database, but you do need to use the external hostname, not the internal one.
Lastly, you will need to use the SSL table and the Use SSL option and then in the SSL Mode dropdown select require.
I prefer DBeaver over pgAdmin, but I come from a Java developer background, so your preferences may differ.
Regards,
Keith
Render Support, UTC+10 
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
