Connect render db to pgAdmin

Question

I'm trying to connect my db from render to pgAdmin, but it always give me this timeout error

I tried this guide and this other guide, but I got the same result

Answer 1

I was able to fix the issue and successfully connect my pgAdmin to my database, which is hosted by Render. (This statement is different than or opposite of your statement "connecting my db from render to pgAdmin").

Anyway, the issue seems to be 'Host name/address' under Connection tab in PgAdmin. Go to Render.com -> Dashboard -> Choose your Postgres database -> Info -> Scroll down to External Database URL (Ignore Hostname).

External Database URL should be something like this

postgres://something_postgres_user:[email protected]/something_postgres

Now, copy only the following portion and paste it to 'Host name/address' under Connection tab in PgAdmin:

postgres://something_postgres_user:SOME_RANDOM_PASSWORD@SOMEHOSTNAME.oregon-postgres.render.com/something_postgres

Answer 2

This worked for me:

From the full External Database URL: postgres://your_postgres_user:your_password@your_host_name.your_region-postgres.render.com/your_db_name

Grab this portion: postgres://@your_host_name.your_region-postgres.render.com

and put into the "Host name/address" field

Fill out "Maintenance database" with your database name

Fill out "Username" with username