how-to Connect to the Retool DB with pgAdmin 4
Thanks
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 ?
thanks
You can find it here - Click on Resource --> Retool Database --> Connection
Use the Postgres Connection URL
If you go to your Retool DB and select Connection
on the dropdown, your connection details should be there. You can click on the 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
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.
@Avner1 Awesome! I removed the images above since they had your connection string in them. Have a great day!