{"id":472,"date":"2020-07-30T07:25:25","date_gmt":"2020-07-30T07:25:25","guid":{"rendered":"http:\/\/thegreenbrain.com.au\/blog\/?p=472"},"modified":"2020-07-30T07:25:31","modified_gmt":"2020-07-30T07:25:31","slug":"connect-to-heroku-postgres-with-pgadmin","status":"publish","type":"post","link":"https:\/\/thegreenbrain.com.au\/blog\/connect-to-heroku-postgres-with-pgadmin\/","title":{"rendered":"Connect to Heroku postgres with pgAdmin"},"content":{"rendered":"\n<p>pgAdmin is the most popular Open Source administration and development platform for PostgreSQL. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to set up pgAdmin<\/h2>\n\n\n\n<p>1.Install the software <a rel=\"noreferrer noopener\" href=\"https:\/\/www.pgadmin.org\/download\/\" target=\"_blank\">here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Create Heroku server connection<\/h2>\n\n\n\n<p>2. Right click on server, select <strong>Create<\/strong> and <strong>Server<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"316\" src=\"https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-8-1024x316.png\" alt=\"\" class=\"wp-image-473\" srcset=\"https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-8-1024x316.png 1024w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-8-300x92.png 300w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-8-768x237.png 768w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-8-1536x473.png 1536w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-8-600x185.png 600w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-8.png 1879w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Add in name for your connection.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"679\" height=\"737\" src=\"https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-10.png\" alt=\"\" class=\"wp-image-475\" srcset=\"https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-10.png 679w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-10-276x300.png 276w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-10-600x651.png 600w\" sizes=\"auto, (max-width: 679px) 100vw, 679px\" \/><\/figure>\n\n\n\n<p>4. Navigate to <strong>Connection<\/strong> tab.  Fill in the credentials from Heroku as documented <a href=\"https:\/\/thegreenbrain.com.au\/blog\/free-data-warehouse-with-heroku-postgres\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"729\" src=\"https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-11.png\" alt=\"\" class=\"wp-image-476\" srcset=\"https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-11.png 678w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-11-279x300.png 279w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-11-600x645.png 600w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p>5. Navigate to <strong>SSL<\/strong> tab and select <strong>Require<\/strong> from SSL mode.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"707\" src=\"https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-12.png\" alt=\"\" class=\"wp-image-477\" srcset=\"https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-12.png 680w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-12-289x300.png 289w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-12-600x624.png 600w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/figure>\n\n\n\n<p>6. Navigate to <strong>Advanced<\/strong> and enter the database name from the Heroku credential as documented <a rel=\"noreferrer noopener\" href=\"https:\/\/thegreenbrain.com.au\/blog\/free-data-warehouse-with-heroku-postgres\/\" target=\"_blank\">here<\/a> in the DB restriction to hide any database that you don&#8217;t have access to.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"679\" height=\"749\" src=\"https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-14.png\" alt=\"\" class=\"wp-image-479\" srcset=\"https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-14.png 679w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-14-272x300.png 272w, https:\/\/thegreenbrain.com.au\/blog\/wp-content\/uploads\/2020\/07\/image-14-600x662.png 600w\" sizes=\"auto, (max-width: 679px) 100vw, 679px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>pgAdmin is the most popular Open Source administration and development platform for PostgreSQL. How to set up pgAdmin 1.Install the software here. Create Heroku server connection 2. Right click on server, select Create and Server 3. Add in name for your connection. 4. Navigate to Connection tab. Fill in the credentials from Heroku as documented&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,13],"tags":[],"class_list":["post-472","post","type-post","status-publish","format-standard","hentry","category-data-analysis","category-postgresql"],"_links":{"self":[{"href":"https:\/\/thegreenbrain.com.au\/blog\/wp-json\/wp\/v2\/posts\/472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thegreenbrain.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thegreenbrain.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thegreenbrain.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thegreenbrain.com.au\/blog\/wp-json\/wp\/v2\/comments?post=472"}],"version-history":[{"count":1,"href":"https:\/\/thegreenbrain.com.au\/blog\/wp-json\/wp\/v2\/posts\/472\/revisions"}],"predecessor-version":[{"id":480,"href":"https:\/\/thegreenbrain.com.au\/blog\/wp-json\/wp\/v2\/posts\/472\/revisions\/480"}],"wp:attachment":[{"href":"https:\/\/thegreenbrain.com.au\/blog\/wp-json\/wp\/v2\/media?parent=472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thegreenbrain.com.au\/blog\/wp-json\/wp\/v2\/categories?post=472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thegreenbrain.com.au\/blog\/wp-json\/wp\/v2\/tags?post=472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}