How-to Connect to the Retool DB with pgAdmin 4

how-to Connect to the Retool DB with pgAdmin 4

Hey @Avner1, mind sharing how you are attempting to connect and the errors that you are hitting?

@Avner1 Looks like you are missing the Host name/address field at the top there. Does this work if you fill that in?

what should be the address ?

You can find it here - Click on Resource --> Retool Database --> Connection
Use the Postgres Connection URL
Screenshot 2023-11-20 at 1.57.52 PM

If you go to your Retool DB and select Connection on the dropdown, your connection details should be there. You can click on the :eye: on the right hand side to display the info.

I enterd the password but still got the same error

I notice that instead of password I copied the PSQL command ....
How can I get the DB password?

You need to copy the PSQL command where the arrow is pointing and paste it into a doc and then where the square outline is in the screenshot that is the password

Screenshot 2023-11-20 at 3.38.14 PM

1 Like

Thanks @ScottR!

@Avner1 You may want to edit image you shared since it has your entire connection string in the error.
Here are some docs on the postgres connection uri.

The general breakdown is as follows:
postgresql://[username]:[password]@[hostname/address]/[dbname]?[additional connection params]

So you can pull the individual pieces out of that string to fill into your PGAdmin connection fields.

THANKS !!! I'm in

1 Like

@Avner1 Awesome! I removed the images above since they had your connection string in them. Have a great day!