Connecting Heroku PostgreSQL using pgAdmin

As we previously mentioned, now is the time to connect from our local location to our Heroku service through pgAdmin. Let's see how to do it:

1. On our local pgAdmin in the browser, we will right-click on Servers and then click on Create | Server...:

Figure Appendix.55 – pgAdmin connection for Heroku

2. On the Connection tab, we will name it Heroku Postgres:

Figure Appendix.56 – Heroku Postgres server setup on pgAdmin

3. Following that, we will add our credentials previously obtained on Heroku on the Connection tab:

Figure Appendix.57 – Heroku Postgres server setup on pgAdmin (cont.)

4. Once the credentials have been validated, we will expand the Heroku Postgres instance and over a public schema, we will right-click and select Query Tool from the contextual menu:

Figure Appendix.58 – Heroku Postgres server expansion

5. On the new Query Editor tab, we can refer to Chapter 2, Setting Up a PostgreSQL RDS...