{"id":5202,"date":"2021-04-23T08:11:35","date_gmt":"2021-04-23T08:11:35","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=ht_kb&#038;p=5202"},"modified":"2022-03-18T13:19:01","modified_gmt":"2022-03-18T13:19:01","slug":"postgresql-database-pgadmin","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/postgresql-database-pgadmin\/","title":{"rendered":"How to Connect Remotely to PostgreSQL Database Using pgAdmin"},"content":{"rendered":"<p>There are a number of GUI client applications that you can use to manage PostgreSQL databases from your computer, remotely over the internet. These applications enable you to view databases, run SQL queries, and more.<\/p>\n<p>Perhaps the most popular and widely-used client application is pgAdmin. This app is free to download &amp; use and there are versions available for almost every operating system, including the major ones like Windows, macOS, and Linux.<\/p>\n<p>This Knowledgebase article will cover how to remotely connect to the database server using pgAdmin so you can run queries and more from your computer.<\/p>\n<h2 id=\"how-to-connect-remotely-to-postgresql-database-using-pgadmin\">How to connect remotely to PostgreSQL Database using pgAdmin<\/h2>\n    \t\t<div class=\"hts-messages hts-messages--danger  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\">Important:<\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tBefore you are able to successfully connect remotely using pgAdmin, you must contact ChemiCloud support and ask that the IP address from the system you are remotely using be whitelisted on the server.<\/p>\n<p>Additionally, some internet service providers, notably Comcast, may block connections over port 5432 and you may need to use a VPN or a different network to connect. ChemiCloud is not able to circumvent this for you if it&#8217;s a limitation from your ISP.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<p>First, you&#8217;ll need to download the latest version of pgAdmin. <a href=\"https:\/\/www.pgadmin.org\/download\/\" target=\"_blank\" rel=\"noopener nofollow\">Click here<\/a> to open the download pages for the application.<\/p>\n<p>Once the application has been downloaded, install it on your computer.<\/p>\n    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\">Version Information:<\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tFor this tutorial, we are using pgAdmin 4 version 5.1.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<p>The first time you open pgAdmin, you need to set up the server so the app knows where to connect. Click Add New Server.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-5203\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-1-783x334.jpg\" alt=\"\" width=\"643\" height=\"274\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-1-783x334.jpg 783w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-1-300x128.jpg 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-1-768x328.jpg 768w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-1-50x21.jpg 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-1-1536x655.jpg 1536w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-1-60x26.jpg 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-1-100x43.jpg 100w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-1.jpg 1922w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>The create server screen will open.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5204\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-1-710x783.jpg\" alt=\"\" width=\"414\" height=\"456\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-1-710x783.jpg 710w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-1-272x300.jpg 272w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-1-45x50.jpg 45w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-1-54x60.jpg 54w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-1-91x100.jpg 91w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-1.jpg 757w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/p>\n<p>Proceed by giving the connection a name that you will remember, for example &#8211; it might say something like, my blog database, or ChemiCloud PostgreSQL.<\/p>\n<p>When you&#8217;ve finished, click the Connection tab at the top.<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/115.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5315\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/115-712x783.png\" alt=\"\" width=\"414\" height=\"455\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/115-712x783.png 712w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/115-273x300.png 273w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/115-45x50.png 45w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/115-55x60.png 55w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/115-91x100.png 91w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/115.png 767w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Use the fields in the\u00a0<em>Connection<\/em>\u00a0tab to configure a connection:<\/p>\n<ul class=\"simple\">\n<li>Enter the IP address or server hostname you wish to connect to. For example, this could be the IP address 1.2.3.4 or a server hostname, like server.serverhostgroup.com.<\/li>\n<li>Enter the listener <strong>port number<\/strong> of the server host in the\u00a0<em>Port<\/em>\u00a0field. The default is\u00a0<strong><em>5432<\/em><\/strong>.<\/li>\n<li>Use the\u00a0<em>Maintenance database<\/em> field to specify the name of the database to which you want to connect.<\/li>\n<li>Use the\u00a0<em>Username<\/em> field to specify the username assigned to the database to which you&#8217;re connecting.<\/li>\n<li>Use the\u00a0<em>Password<\/em> field to provide a password that goes with the database user account you&#8217;re using.<\/li>\n<li>Check the box next to\u00a0<em>Save password?<\/em> to instruct pgAdmin to save the password for future use if you want.<\/li>\n<\/ul>\n<p>When you&#8217;ve finished, click Save. The pgAdmin app will attempt to connect to the server automatically, and the setting will be changed so the next time you open pgAdmin, you&#8217;ll be able to connect easily.<\/p>\n<p class=\"p1\"><b>Are you struggling with PostgreSQL connectivity issues? ChemiCloud is the hosting solution designed to save you time! <\/b><span class=\"s1\">\ud83e\udd13<\/span><b> Check out our <\/b><a href=\"https:\/\/chemicloud.com\/pricing#60b65e4e63b58\"><span class=\"s2\"><b>web hosting <\/b><\/span><\/a><b>plans!<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are a number of GUI client applications that you can use to manage PostgreSQL databases from your computer, remotely over the internet. These applications enable you to view databases, run SQL queries, and more. Perhaps the most popular and widely-used client application is pgAdmin. This app is free to&#8230;<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"ht-kb-category":[224],"ht-kb-tag":[],"class_list":["post-5202","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-postgresql-databases"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/5202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/comments?post=5202"}],"version-history":[{"count":8,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/5202\/revisions"}],"predecessor-version":[{"id":7225,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/5202\/revisions\/7225"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=5202"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=5202"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=5202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}