Connecting to render database via IntelliJ

[k-g-j]

Does anyone in the community have experience connecting to their Render database via the Data Sources option in Intellij? I have tried filling out the fields in this image based on what I see in my Render dashboard, but I aways get an error. Thanks!

[Keith]

Hi there,

Can you please share the error message you see?

If you fill out the host, port, database and username/password fields, it should work. Make sure you use the external hostname. You will also need to go to the SSH/SSL tab and make sure SSL mode is set to required.

Regards,

Keith
Render Support, UTC+10

[k-g-j]

Hi thank you for following up! This is the error

DBMS: PostgreSQL (no ver.)
Case sensitivity: plain=mixed, delimited=exact
The connection attempt failed.

I have set SSL to required, as you said.

Here is an image of my render dashboard and the values I am placing in IntelliJ

Host: cooks-corner.onrender.com
Port: 5432
Username: kate_johnson
Password: copied from Render
Database: cooks_corner

[Keith]

HI there,

Have you downloaded the JDBC drivers for Postgres? Which IntelliJ plugin are you using to connect to Postgres?

Regards,

Keith
Render Support, UTC+10

[k-g-j]

I am using the default Data Source within IntelliJ and I have installed the JDBC driver.

[Keith]

Hi there,

It looks like you may be pasting our URL into the URL field in IntelliJ. This won’t work, as the URL needs to be JDBC formatted, and our URL is in the standard URL format. You will need to convert it to JDBC format, or fill out the host, port, database, username and password fields separately.

Regards,

Keith
Render Support, UTC+10

[k-g-j]

So I am filling out the fields separately and IntelliJ auto-populates the URL field

jdbc:postgresql://cooks-corner.onrender.com:5432/cooks_corner

Here is the error when I try to connect

DBMS: PostgreSQL (no ver.)
Case sensitivity: plain=mixed, delimited=exact
The connection attempt failed.

[Keith]

Hi there,

Is that the real host you are using? If so, you need to take the connection details from the external URL of your Postgres service.

I could connect from IntelliJ to my Postgres services.

Regards,

Keith
Render Support, UTC+10

[Keith]

Hi there,

You have just posted your Postgres services credentials to a public forum. Please delete your service and create a new one. If you want to export your data and import it into a new database, you can use these instructions here. I have redacted the private details from your Postgres URL.

The external Postgres URL are the details you need.

I think, at this point, it would be best if you open a ticket directly with us using the Contact Support link in our dashboard if you need any further assistance.

Regards,

Keith
Render Support, UTC+10