Question 89727 in PostgreSQL Question posted in
The official documentation can be found here.

Connect render db to pgAdmin – Postgresql

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

Tags:

2

Answers


  1. 0

    I haven’t used render DB before, but I will suggest you check if your render DB instance is created as public, or allows external connection.

    Login or Signup to reply.
  2. 0

    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

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search