February 21, 2021

How to connect Heroku Postgres from pgAdmin?

1. Install pgAdmin if you haven't installed it. 

2. Go to Resources Tab and click "Heroku Postgres".


3. Click Settings. Click Credentials.
 
4.  Select Add New Server in pgAdmin.


5. In General Tab, enter a name. Then, select Connection Tab.
 
a. Host from Heroku should be the Host Name/Address.
b. User from Heroku should be the Username.
c. Password from Heroku should be the Password.
d. Database from Heroku should be Maintenance Database.

6. Click "Save" button.

7. Find your Database and right click the Table and select Query Tool.


8. Run sample SQL like below.

 
Note:
Restart your PC if you face any issues.

No comments:

Post a Comment